Headcount each hour by department or location

[sjohn627]

I need to calculate the number of employees scheduled to work each hour, each day of the week, and also by location or department. I have made the following formula which totals up nicely the total employees working per hour, but I am not sure how to also do by location/department.

=COUNTIFS(Employees!$W$3:$W$149,"<="&'Headcount Totals'!A19,Employees!$X$3:$X$149,">="&'Headcount Totals'!A19)

Employees is a tab and Headcount Totals is the tab I am inserting the formula to make a few spreadsheets. Any suggestions?

 

[maabadi]

Welcome to MrExcel MessageBoard.
Add one more Criteria range for Locations/Departments Range and one Criteria for Location/Departments you want.