INDIRECT Problem

J

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
 
V

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
 
Top