View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Formula for calculating a rolling 12 month average in excel?

Depends upon how the data is structured. It could be as simple as

=AVERAGE(A1:A12)

and copied down, if the data is accumulated per month in A1:An, but it may
be more complex.

Give us an example.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jeff" wrote in message
...
I cannot remember how to calculate a 12 month rolling average for my
emissions. I believe I know the formula but need some reassuring.

Thanks.