ExcelBanter - Sum YTD Colums

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum YTD Colums (https://www.excelbanter.com/excel-discussion-misc-queries/3535-sum-ytd-colums.html)

Firs Off Thanks For All your help.
I have the folowing Lay Out
A B C D E E F
1 Actual Apr
2
3 Part Jan Feb Mar Apr May YTD
4 G115 100 100 300 500 300
5 G116 0 500 200 200 200
6 G117 200 500 300 200 500
7 G118 300 0 0 200 500

I need the Ytd coulum to sum the sales in base of Cell B1 that will be
updated, in this case i need the total YTD sales For Apr.

I think it has somthing to do with Sum(offset()) but i dont know how.

One way...try this in G4 and fill down:

=SUM(OFFSET(F4,,,,MATCH($B$1,$B$3:$F$3,0)-6))

HTH
Jason
Atlanta, GA

-----Original Message-----
Firs Off Thanks For All your help.
I have the folowing Lay Out
A B C D E E F
1 Actual Apr
2
3 Part Jan Feb Mar Apr May
YTD
4 G115 100 100 300 500 300
5 G116 0 500 200 200 200
6 G117 200 500 300 200 500
7 G118 300 0 0 200 500

I need the Ytd coulum to sum the sales in base of Cell
B1 that will be
updated, in this case i need the total YTD sales For
Apr.

I think it has somthing to do with Sum(offset()) but i
dont know how.
.