Thanks Biff, that was exactly what I was looking for.

"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"))


--
Biff
Microsoft Excel MVP


"Gav123" wrote in message
...
Hi,

I have the following formula
=SUM(January!BM9,February!BM9,March!BM9,April!BM9, May!BM9,June!BM9,July!BM9,August!BM9,September!BM9 ,October!BM9,November!BM9,December!BM9)
Which works fine but I would like to shorten it.
I have a sheet called Data with a list of the months in range A13:A24 and
I
was wondering if I could use the INDIRECT function instead?? If so can you
please provide the correct formula for the above.

Thanks in advance,

Gav