Double counting based on COUNTIFS with OR statement

Originally Posted by martindwilson

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks for your help as well, attached is the sample worksheet. Thanks for the instructions!

The important thing here is to count the total agents that worked on a time frame, without duplicating agents due that sometimes they log multiple times during time frames. It is not necessary to least all agent names, but that is the only way I have been able to make some progress