i need help with the "count" function
 

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???

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

=SUMPRODUCT(--(Sheet1!$A|$1:$A$1000A1),--(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)


"kippercat" wrote in message
...
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???