Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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??? |
#2
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I count in an array based on a function? | Excel Worksheet Functions | |||
PivotTable Macro Reverts to Count Function | Excel Worksheet Functions | |||
COUNT function and errors within it - Need some expert knowledge | Excel Discussion (Misc queries) | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Sum and Count Function | Excel Worksheet Functions |