INDIRECT Problem

[JHarriman]

I am wanting to use the INDIRECT function in my cell formula and hav
ran into a problem. A sheet name of Jan 06, Feb 06 etc. will not work
I have put Feb 06 in location O1. This formula
=SUM(INDIRECT(O1&"!44:44")), will not work with Feb 06. But it wil
work with just a month name like Feb. I would like to keep my separat
sheet names of month and year.

Thanks for any Help.
Jo

 

[vezerid]

Joe

Your formula is missing the single quotes needed when the sheet name
contains spaces.

=SUM(INDIRECT("'"&O1&"'!44:44"))

Notice the single quote inside double quotes prepended and the single
quote inserted before the exclamatino mark.

HTH
Kostis Vezerides