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
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>