Rolling 3 mth Average

G

Guest

I have data like this:
Jan 100
feb 200
mar 300
apr 500
may 600
jun 0
july 0
aug 0
etc.

This is updated monthly and I would like to calc a 3 mth average each month
with the new data. One month would drop off another would be added. How do
I do this in a formula? Thanks.
 
R

Roger Govier

Hi

With your data in A1:B12 enter in cell C3
=AVERAGE(B1:B3)
Copy the formula down column C using the fill handle.

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to use Formula to resolve 5
YTD % over 12 accumulating figures 1
Rolling average 2
Growth Rate for number series 1
drag formula down from columns that go acros 3
Hlookup and sum noncontiguous numbers 1
Create a 12 month rolling average 15
look up / match / reference cell 6

Top