Calculate a moving average

  • Thread starter Thread starter Gib Montgomery
  • Start date Start date
G

Gib Montgomery

I want to calculate moving averages on a large spreadsheet by adding a column
(BB) and deleting another (O), daily.
When I add new data by inserting a new column (BC) and deleting the old one
(O) my newest5 information is then in Column BB, but the formula for
averaging - originally written as =AVERAGE(O7:BB7) changes to
=AVERAGE(O7:BA7), and ignores the new column of data.
Manually changing the formula each time is a pain.
Every suggestion is welcome. My fingers are getting sore.
 
This one will "provide the same merchandise":
=AVERAGE(OFFSET($O$7,,,,40))
Micky
 
Back
Top