i need help with the "count" function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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???
 
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)
 
Back
Top