Sum multiple worksheets and summary tab that would sum and count by rep name

angie.chang · #1 05-15-2013, 09:12 AM

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.

I am using excel 2010.

Someone told me to create a name list and use the formula below. I think I am doing my name list incorrectly. I keep getting #REF!

=SUMPRODUCT(COUNTIF(INDIRECT("'"&SheetList&"'!c:c" );B3))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word count in multiple documents	cyberpaper	Word	5	07-27-2012 07:31 PM
How can I count multiple usage of the same words?	coffee_king	Word VBA	1	03-24-2012 07:52 PM
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Count with multiple conditions	bundy5150	Excel	4	02-22-2011 10:00 AM
Help with worksheets on Word	eballi	Word	4	11-18-2009 05:17 AM