| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to sum cells across different worksheets in different l
TM,
Here's what I ended up getting to work by putting my worksheet names in AA1 to AA21 on my summary worksheet. =SUMPRODUCT(SUMIF(INDIRECT("'"&$AA$1:$AA$22&"'!$D$ 4:$D$100"),D4,INDIRECT("'"&$AA$1:$AA$22&"'!$B$4:$B $100"))) =SUMPRODUCT(SUMIF(INDIRECT("'"&$AA$1:$AA$22&"'!$D$ 4:$D$100"),D4,INDIRECT("'"&$AA$1:$AA$22&"'!$C$4:$C $100"))) Thanks for everyone's help! John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reference a cell as PART of a vlookup "Table_Array" locat | Excel Worksheet Functions | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| sum of different cells in different worksheets??? | Excel Worksheet Functions | |||
| sum of different cells in different worksheets??? | Excel Worksheet Functions | |||
| Sum of cells in different worksheets | Excel Worksheet Functions | |||
Hybrid Mode
