Typo!

hgrove wrote...
...
=SUMPRODUCT(SUMIF(INDIRECT("'"&WSList&"'!A1"),B 5,
INDIRECT("'"&WSList&"'!R40)))

Make that


=SUMPRODUCT(SUMIF(INDIRECT("'"&WSList&"'!A1"),B5,
INDIRECT("'"&WSList&"'!R40")))


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=319431