SUM, OFFSET FORMULA PLEASE

[srizki]

I have 13 columns with headings Jan, Feb Mar….Dec, and YTD, column. The YTD column should add up to the month showing in cell say N1 (That month list with validation), so when I change the month the so the sum of YTD should change according to that month.
Thanks

 

[Domenic]

Assuming that A1:L1 contains the date (Jan, Feb, Mar, etc.), A2:L2 contains the data, and N1 contains the month of interest, such as Mar, try...

=SUM(A2:INDEX(A2:L2,MATCH(N1,A1:L1,0)))

Hope this helps!

 

[srizki]

Thank you Domenic,
I learned something new today.