One way ..
Assume the set-up below, months in col A, from row2 down,
the values in col B, & the rolling 12 month total to be in B1
Mth-Yr <R12m-Total>
Aug-04 50
Sep-04 80
Oct-04 70
Nov-04 10
Dec-04 50
Jan-05 90
Feb-05 20
Mar-05 90
Apr-05 40
May-05 40
Jun-05 70
Jul-05 40
....
Put in B1:
=SUM(OFFSET($A$1,MATCH(OFFSET($A$1,COUNTA(A:A)-1,0),A:A,0)-1,1,-12))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"D" <[email protected]> wrote in message
news:[email protected]...
> I would like to set up my spreadsheet to give me a running 12 month total,
by
> dropping the oldest data and using my current data. i.e. january thru
dec
> totals then in next jan the previous year would drop off when I input
current
> jan totals.
>
> Thanks again for your help
>
> D
Bookmarks