I am wanting to use the INDIRECT function in my cell formula and have
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 will
work with just a month name like Feb. I would like to keep my separate
sheet names of month and year.

Thanks for any Help.
Joe


--
JHarriman
------------------------------------------------------------------------
JHarriman's Profile: http://www.excelforum.com/member.php...o&userid=31739
View this thread: http://www.excelforum.com/showthread...hreadid=514909

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