Hi
have a look at these two ways and adapt as needed.
1/ =SUM(OFFSET($AL$14,COUNTA(AL14:AL100)-1,0,-12,1))
2/ =SUM(OFFSET($AL$14,MATCH(DATE(2014,6,1),A14:A100,0 ),0,-12,1)), change the date as required to sum the previous 12 months from that date.
Note: The dates in A14:A37 are the 1st of each month & formatted as mmm yyyy.
Quote:
Originally Posted by comp1
Dec 2013- Nov 2014 (just to see if it grabs the last 12 months)
Total column
0.5
0.0
2.0
0.0
0.0
0.0
0.0
0.0
0.5
0.5
2.0
2.0
Total should be 7.5 but when I use the formula it comes back 7.0.
The previous months still contain numbers in the total column. Do they have to be cleared for it to work?
|