View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dallin
 
Posts: n/a
Default 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