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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,368
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,112,884
Messages
5,543,023
Members
410,583
Latest member
gazz57
Top