If Statement...Nesting Limit

[sforney123]

Running Excel 2007. I'm trying to use the following formula to sum up data.. =if(B7="Jan",sum(N7:T7),if(B7="Feb",sum(P7:W7),if(B7="Mar",sum(F7:M7).... etc. If I do this for all 12 months excel gives me the error that I reached the nesting limit. Does anyone know another formula that might work? If there is a VBA solution that would be good as well.

[Ron Coderre]

Try expanding this regular formula...
=SUM(CHOOSE(MONTH(B7&" 1"),N7:T7,P7:W7,F7:M7))
or this one
=IF(B7<>"",SUM(CHOOSE(MONTH(B7&" 1"),N7:T7,P7:W7,F7:M7)),"no month")

Is that something you can work with?

[sforney123]

The first statement worked splendidly...Thank you!