Sumif across multiple work sheets

[Hollywoood]

Hi all,

I have about 20 work sheets that I am trying to get a sumif statement to work across but I keep getting an error.

I first tried a very basic form hoping it would work

=sumif(Start:End!G17,=K21,Start:End!J18)

This didnt seem to work so I looked on the forms and found an old thread that suggested the following

=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A2:A10"),D2,INDIRECT("'"&SheetList&"'!B2:B10")))

Where the instructions are to replace SheetList with your own sheet list. Would I simply replace the following?

SheetList with Start:End
A2:A10 with G17
D2 with K21
B2:B10 with J18

Ive tried a straight substitution but I am getting an error, any thoughts?

Thanks so much in advance

 

[Brian from Maui]

sheetlist is a named range consisting of your relevant sheet names.

Yes & Yes

 

[Hollywoood]

Thanks Brian,

I actually came to that realization after reading a little more and trying some options. Given the number of Sheet names that can exist, is there an option to do a Start:End option to encompass all sheets inbetween those or do I need to add each individual sheet name to my list?

Thanks!