Or this

=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&{1,2,3}&"'!B1" ),"x",INDIRECT("'Sheet"&{1,2,3}&"'!A1")))

since there is only one criteria range


--


Regards,


Peo Sjoblom


Ok, I think I've figured out what you're asking....

Sum A1 on all sheets where B1 = some category.

Try something like this:

=SUMPRODUCT(--(T(INDIRECT("'Sheet"&{1,2,3}&"'!B1"))="x"),N(INDIR ECT("'Sheet"&{1,2,3}&"'!A1")))

Where "x" = category

--
Biff
Microsoft Excel MVP