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.


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