Trying to sum across multiple sheets

[Excelski]

Hello,

I am using

Please Login or Register  to view this content.

which works fine
I would like to expand it to sum across multiple sheets between First:Last but i can't get it to work.

Any help greatly appreciated

Kevin

[Haseeb Avarakkan]

Hello Kevin,

One way: Enter your sheet names (First to Last) in a range & define a name ie: SheetList, then use

=SUMPRODUCT(SUMIFS(INDIRECT("'"&SheetList&"'!L6:L9"),INDIRECT("'"&SheetList&"'!J6:J9"),">="&Master!K4,INDIRECT("'"&SheetList&"'!J6:J9"),"<="&EOMONTH(K4,0)))

[tim201110]

https://www.excelforum.com/excel-gen...ain-sheet.html

[AliGW]

Tim - linking to another pertinent thread is fine in principle, but you have linked to a thread where the problem was never resolved, so it's not really very helpful. It hints at a solution IF you know what you are looking for, but may be of little or no use to Excelski. If you can explain how to do this, then please do so here in this thread. Thanks.

[Excelski]

Hello Haseeb,

Thank you for your solution it works great, at first I had Ref error but this was due to one of the sheets on my list was missing.
Thanks to everyone who took the time to look

Kevin