i need help with the "count" function

[Guest]

hi, i am trying to create a second sheet in my workbook that counts the
number of people in my excel staff rota that work between 07:00 to 08:00 and
08:00 to 09:00 and so on, basicaly a head count for every hour of the day,
any ideas???

 

[Bob Phillips]

Put the start time in A, end time in B, and then use

=SUMPRODUCT(--(Sheet1!$A|$1:$A$1000>A1),--(Sheet1!$A$1:$A$1000<=B1))

and copy down for all the time slots

--

HTH

RP
(remove nothere from the email address if mailing direct)