ExcelBanter - Rolling 3 mth Average

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rolling 3 mth Average (https://www.excelbanter.com/excel-worksheet-functions/56783-rolling-3-mth-average.html)

dallin

Rolling 3 mth Average

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.
--
thanks, mc

Roger Govier

Rolling 3 mth Average

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

dallin wrote:
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.

All times are GMT +1. The time now is 06:06 AM.