P Peg Jul 30, 2004 #1 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?
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 Jul 30, 2004 #2 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)
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)
