"T. Valko" wrote...
"Harlan Grove" wrote in message
"T. Valko" wrote...
....
=SUMPRODUCT(SUMIF(INDIRECT("'"&A13:A24&"'!BM9") ,"<1E100"))
....
=SUMPRODUCT(N(INDIRECT("'"&A13:A24&"'!BM9")))
....
It probably would but the SUMIF version is more robust.

The SUMIF formula handles multiple cell ranges in each worksheet.
Whether trapping error values is a good thing is arguable. Then again,
the SUMIF formula is slower. It's a trade-off.