"Harlan Grove" wrote in message
...
"T. Valko" wrote...
Marcelo's suggestion is the best solution but this is how it can be done
using your list of sheet names:

=SUMPRODUCT(SUMIF(INDIRECT("'"&A13:A24&"'!BM9"), "<1E100"))
...

Why SUMIF? Wouldn't

=SUMPRODUCT(N(INDIRECT("'"&A13:A24&"'!BM9")))

suffice?

It probably would but the SUMIF version is more robust.


--
Biff
Microsoft Excel MVP