| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting how many employees are scheduled to work by hour
Hi,
I am using the below formula to count how many employees are scheduled to work by hour but it is not counting if the shift starts in the PM and ends in the AM. =SUMPRODUCT(($B$3:$B$24<=$A36)*($C$3:$C$24=$A37)) Thank you for your help in advance. -- Amin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need formula for counting employees by hour | Excel Worksheet Functions | |||
| Clearing scheduled work hours for weekends. | Excel Worksheet Functions | |||
| Clearing scheduled work hours for weekends | Excel Worksheet Functions | |||
| Counting The Number of Employees | Excel Discussion (Misc queries) | |||
| How can i set up work schedule for 5 employees | New Users to Excel | |||
Threaded Mode
