I have multiple worksheets within the workbook. There are tab 1,2, 3, etc. Each tab represent days of month(May).

I have a rep stats summary tab to sum up by rep. I would like to know if there is a easier way to create this formula? A rep may be listed more than one time in a day or per tab.


Attached is a copy of the excel. I am trying to see if there is a faster to sum up all worksheets and count rep in the summary tab.

Thanks,