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

A

angie.chang

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 i
there is a easier way to create this formula? A rep may be listed mor
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 faste
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.
think I am doing my name list incorrectly. I keep getting #REF!


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

+-------------------------------------------------------------------
|Filename: Copy of QA Tracker - Shawn Byun - May.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=875
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple worksheets and summary tab that would sum and count by rep name 0
sumproduct with COUNTIF With An INDIRECT 1
Multiple worksheet summary 4
Problem with Formula of IF/AND/COUNT/SUM 0
Sum Across Multiple Sheets 1
Recalc of SUM() that refers to a cell across a range of worksheets 4
Sum formula across multiple tabs and fields 5
Sum multiple worksheet sales data by month 4

Top