| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum multiple worksheets and summary tab that would sum and count by rep name
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)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Summary from multiple worksheets | Excel Programming | |||
| Summary of multiple worksheets | Excel Discussion (Misc queries) | |||
| Summary count from different worksheets? | Excel Discussion (Misc queries) | |||
| Summary sheet for multiple worksheets | Excel Discussion (Misc queries) | |||
| Summary sheet for multiple worksheets | Excel Programming | |||
Threaded Mode
