Long Nose
Board Regular
- Joined
- Nov 19, 2007
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
Originally Posted by Aladin Akyurek View Post
You could create on every relevant sheet an additional column, say, G, with"
=MONTH(A2)
Then invoke:
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!G2:G188"),MONTH($A6),INDIRECT("'"&SheetList&"'!F2:F188")))
where SheetList refers to a range housing the relevant sheet names, that is, 3107, 3207, etc.
I have this great formula that Aladin created and I'd like to add one more criteria to the MONTH($A6).
Here's my current formula
=SUMPRODUCT(--(SUMIF(INDIRECT("'"&Sheetlist_New&"'!A9:A200"),ED3,INDIRECT("'"&Sheetlist_New&"'!E9:E200"))),--(SUMIF(INDIRECT("'"&Sheetlist_New&"'!AB9:AB200"),MONTH(EL5),INDIRECT("'"&Sheetlist_New&"'!E9:E200"))))
The result here isn't adding an additional criteria, but taking the second criteria times the first.
So, I'm trying to now add a second criteria before E9:E200, but the formula is erroring out.
=SUMPRODUCT(SUMIF(--(INDIRECT("'"&Sheetlist_New&"'!A9:A200",ED3),--(INDIRECT("'"&Sheetlist_New&"'!AB9:AB200",MONTH(EK5))),INDIRECT("'"&Sheetlist_New&"'!E9:E200"))))
Can anyone see my error?
Last edited: