Create a list with the names of all sheets in this workbook that you want to
include in your sumif, assume you have 10 sheets and you put the names in
H1:H10, then you can use for example

=SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H10&"'!A1:A100") ,"Yes",INDIRECT("'"&H1:H10&"'!B1:B100")))


that would be the equivalent of

=SUMIF(A1:A100,"Yes",B1:B100)

where you would sum all entries in B1:B100 where A1:A100 is Yes


--
Regards,

Peo Sjoblom




"dee" wrote in message
...
Is it possible to sum ranges from more than one worksheet. I know I do a
Sumifs + Sumifs, but would rather not.

Thank you.

--
Thanks!

Dee