Gosh! I've tried all variations but this one. Thanks a bunch.

KL

"Myrna Larson" wrote in message
...
You're right, it doesn't work. I don't know why -- I think it should. But
this
variation does:

=SUM(Jan:INDIRECT(A1))


On Sat, 22 Jan 2005 19:45:22 +0100, "KL"

wrote:

Hi Myrna,

I assumed the OP did InsertNameCreateTop Row. Curiously, if I do
=SUM(Jan:Mar) it works, but my suggested =SUM(INDIRECT("Jan:" & A1)) seems
to only return Jan not the whole range. Must be something about INDIRECT
(I
seem to recall having read something about it, but not sure).

Regards,
KL



"Myrna Larson" wrote in message
. ..
Why does it not work? Your original post implies that you have named the
ranges for each month. Is that not correct?


On Sat, 22 Jan 2005 10:22:55 +0100, "KL"

wrote:

Sorry, this won't work.

KL

"KL" wrote in message
.. .
Hi Channing,

How about this:

=SUM(INDIRECT("Jan:" & A1))

Regards,
KL

"Channing" wrote in message
...
I need to nest over 7 IF statements and didn't find the answer I
needed
in
the other posts. I need to check the month in cell a1 for the month
to
determine the YTD Budget. IE if a1= "May", sum(Jan:May),if
a1="June",
sum(Jan:June).

Thanks for the help.