# of employees staffed at specific times of the day

Hi all,

First post . I'm hoping to get some assistance on the attached worksheet. I'm trying to figure out how many employees are staffed based on their schedule at different times of the day (15 minute time slots).

I think its simpler than I think but I've been trying sumifs and sumproduct formulas but they don't seem to be working correctly for me. I'm not sure if its the data or my formulas but hopefully some may be able to assist.

I just need to count the # of employees in column B based on the time slot in column A. The employee work schedules are listed on the right, columns D:L.

Any help is appreciated! Thanks!