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)
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)