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.