Sum YTD Colums

[Guest]

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.

 

[Jason Morin]

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