Count of employees by date by region

I was able to locate another thread that showed how to use COUNTIF to determine the number of scheduled employees based on Start and End times and I was able to modify that towards active employees based on Start and End dates. But, I am trying to add in a condition based on region.


I have tried using SUMIF, SUMPRODUCT and various combinations with no luck.

If anyone has any suggestions, it would be greatly appreciated.

With sumproduct (see example)

Perfect! Thank you. I was making it much too difficult.


(now, I'll go update the thread to SOLVED).

Glad i could help you.

Thanks for the feedback.