SUM, OFFSET FORMULA PLEASE

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,403
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

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Thank you Domenic,
I learned something new today.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,099
Messages
5,576,128
Members
412,698
Latest member
Lilly13m
Top