Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum YTD Colums
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. |
#2
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use side by side colums and stacked columns in same graph? | Charts and Charting in Excel |