Sum a range of columns depending on current month

[excel-er-8]

Hi all,

I'm looking for a formula that will sum a range of columns based on current month. If current month is January, sum A2 thru L2. In Feb, sum B2 thru L2. In March, sum C2 thru L2. I'm hoping there is something other than a big nexted IF. Thanks!

 

[Fluff]

How about

=SUM(INDEX(A2:L2,MONTH(TODAY())):L2)

 

[JamesCanale]

MrExcelPlayground.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Answer
2	10	15	20	25	30	35	40	45	50	55	60	65	425
Sheet39

Cell Formulas
Range	Formula
M2	M2	=SUM(OFFSET(A2,0,MONTH(TODAY())-1,1,13-MONTH(TODAY())))

 

[SewStage]

How about

=SUM(INDEX(A2:L2,MONTH(TODAY())):L2)

This worked perfectly for me and exactly what I was looking for - thank you, Fluff!!

 

[Fluff]

Glad we could help & thanks for the feedback.