This is a bit of a long request for help, but I will try my best to include all information. I have a 6 week work schedule for 350 people. It rotates every 6 weeks because each person has a (1) scheduled training day in those 6 weeks. What I am trying to compile would be a daily wrap up of how many people are on shift (not including people in training or of course on days off), by half hour, and then do that for each day of the rotation. Attached is the information that I have to work with. I have flirted around with IF, AND, and SUMIF statements, but I think this one will be a lot more complex than just those. As always, I will help to answer any question that you may have.