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 ...
Perhaps
=SUMPRODUCT(
($N$3:$N$18 >=$P3) *
($N$3:$N$18 >=$Q3) *
($L$3:$L$18 <= $P3) *
($H$3:$H$18="Overtime")
)for
