Are the rest of the sheets named the same way, Sheet13, Sheet14,
Sheet15, etc?


bruce42 Wrote:
I tried the following with limited results:

=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT(" 1:12"))&"'!A11:A17"),A4,INDIRECT("'Sheet"&ROW(INDI RECT("1:12"))&"'!B11:B17")))

It works for up to 12 worksheets, but after that it returns a #ref
error. I had no luck with the other formula you suggested, but
perhaps I'm not getting the syntax correct for the sheet names.
Thanks.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=381963