You were right. After rebuilding the document I can now calculate all
of the sheets in the workbook with no problems. I must have made a
typo somewhere in the first version. Is there a way to perform the
same function with worksheets that do not have linear names, such as
"Status, Monday, Tuesday, etc.?
The current version of the formula is:
=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT(" 1:16"))&"'!A11:A17"),A4,INDIRECT("'Sheet"&ROW(INDI RECT("1:16"))&"'!B11:B17")))
--
bruce42
------------------------------------------------------------------------
bruce42's Profile:
http://www.excelforum.com/member.php...o&userid=24609
View this thread:
http://www.excelforum.com/showthread...hreadid=381963