Avatar of Tom M
Tom M

asked on 

Count if statement

I am hoping to count the number of calls listed as answered in the data tab column D, when the agent name (column a) matches on the summary tab and data tab and when the times on data tab column J fall between the timestamps in row 1 of the summary sheet.

Basically, for the 08:00:00 AM column, we would count the number calls lists as answered for Agent Dispatch, Dispatch on the Data sheet that was greater than 08:00:00 AM and less than 09:00:00 AM.  This would continue across the sheet counting the number of calls each agent is answering in those time periods

test file.xlsx

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon