In a Budget/Actual spreadsheet I would like to be able to sum the
monthly budget values in a year-to-date cell that corresponds to the
number of months of the year that have elapsed. I use a Name value
"Month" in a cell that represents "year-to-date-thru".

I have tried to accomplish this by using a nested IF statement the
matches the "Month" with a string of (+) to sum the values from the
appropriate cells, i.e., +F12+I12+L12 for the "Mar" entry. This
obviously creates a very long nested IF which seems to fail if I go
beyond the 9th nest or "Sep".

Is there a better way to do this? Is there an upper limit on the
number of nested IFs?

Thanks,

Lram


--
Lram


------------------------------------------------------------------------
Lram's Profile: http://www.excelforum.com/member.php...nfo&userid=238
View this thread: http://www.excelforum.com/showthread...hreadid=528887