Forum Discussion
Count if between range of times
I have a spreadsheet with two sets of data. One has Overtime with start and end time and on the other tab I have a table to 30 minute intervals and I am trying for excel to tell me how many people I have working OT during that 30 minute interval. I can't figure it out. Please help
There is no set of people in your OP. Impossible to answer. Probable answer: Loop thru people with BYROW, FILTERing the other tables to figure out what OT they are doing.
Perhaps
=SUMPRODUCT( ($N$3:$N$18 >=$P3) * ($N$3:$N$18 >=$Q3) * ($L$3:$L$18 <= $P3) * ($H$3:$H$18="Overtime") )for
