Using Sumif on multiple tabs

[Peg]

Is there a way to get the sumif function or something
like that to do a "search" on multiple tabs and bring
back a sum?

 

[hgrove]

Peg wrote...

Is there a way to get the sumif function or something like that
to do a "search" on multiple tabs and bring back a sum?

General example:

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"One";"Two";"Three"}
&"'!"&CELL("Address",ReferenceRangeToCheck)),Criteria,
INDIRECT("'"&{"One";"Two";"Three"}&"'!"&
CELL("Address",ReferenceRangeToSum)