I am looking for help for a formula that is helping me determine daily production on an agent level. The attached document has two tabs (sheet 1 and sheet 2)
Sheet 1 has daily production across multiple lines. The key columns are column F with Open date and column Z with Agent name
Sheet 2 has details on worked time and different aux totals from the phone system. Sheet 2 also has column A with date and column B with Agent name.
What I need is on sheet 2 in column S to have the formula grabbing the daily total production (sum of lines with the agents name) to be shown.
For example:
Agent A on 9/4/22 worked 2 call logs
Agent A on 9/5/22 worked 4 call logs
Agent A on 9/6/22 worked 0 call logs
Bookmarks