| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF over multiple spreadsheets
Hi,
I would like to use the following formula over 30+ worksheets in the same workbook but I do not want to have to repeat sum if over and over again. I have tried my own research and most people suggest sumif with sumproduct and indirect but I cannot get my head round it. This is the formula I am using at the moment: =(SUMIF('SMITH S'!V$4:V$22,C5,'SMITH S'!W$4:W$22)) 'Smith S' is an employee name and the other sheets are all named in that format. I have created a list and defined a name for it called 'tabs'. I understand you need to do this for the indirect function? Can some body reply with the formula I need to use that includes my other 30 worksheets please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update multiple spreadsheets in multiple workbooks | Setting up and Configuration of Excel | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| SUMIF - counting across different spreadsheets | Excel Worksheet Functions | |||
| SUMIF with multiple criteria for multiple columns to sum a single | Excel Programming | |||
| How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
Threaded Mode
