I am usually really good at figuring out formulas but I am kind of stuck on this one.



I have a HUGE spreadsheet that I use to complete a schedule for employees. They can be scheduled in different areas at different times. I am trying to write a formula that will count the amount of people in an area that start at or before a certain time.

Example in cells a11 through c15
A10=AREA B10=Shift Start C10=Shift End
A11=DD B11=0600 C11=1400
A12=DD B12=1400 C12=1900
A13=hr B13=0600 C13=1200
A14=DD B14=0700 C14=1500
A15=rr B15=1700 C15=2200

So you probably figured out the columns b and c are in military time format.

I am trying to write a formula that will count all of the people scheduled in area DD that are scheduled at or before 0700. I will be writing this formula for each area code and will make another one for associates that close (leave last)

I am aware of the sumif, and countif but they only give me the ability of 1 criteria. I want to stay away from VBA unless I have to and I would like to not have to use the sumproduct formula since it slows things down when there are alot of them. (we are talking around 400 formulas)

Thanks