Using Sumif on multiple tabs

P

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?
 
H

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?
Click to expand...

General example:

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