Creating a Completion Per Agent Dashboard


I need to create a dashboard that shows how many emails each agent has completed. I have a main sheet that everyone enters in how many emails they completed. So in 1 column, Emails Completed, then in a 2nd column I have a dropdown contact list to choose your name from, then the time you started, ended, and the date.

Something like this: =SUMIF([Emails Completed]1:[Emails Completed]8, "User1", month) which ideally would look for the contact, and add up the emails they had completed per month to then be inserted into the dashboard. Any ideas? Thanks!

Best Answer