rolling average formula

  • Thread starter Thread starter Graham Hill
  • Start date Start date
G

Graham Hill

I'm sure this a snap for the sharks...

I wish to create a formula for a basic daily rolling average, up to now I
have been typing in a formula for each day which is time consuming and very
inefficient, as follows...


Sequence Value Average
formula
day #1 25 25 `= 25/1
day #2 5 15 `=30/2
day #3 3 11 `=33/3
day #4 6 9.8 `=39/4
day #5 13 10.4 `=52/5
day #6 10 10.3 `=62/6
day #7 12 10.6 `=74/7
day #8 25 12.4 `=99/8
and so on



thanks for any help

Gra
 
I'm sure this a snap for the sharks...

I wish to create a formula for a basic daily rolling average, up to now I
have been typing in a formula for each day which is time consuming and very
inefficient, as follows...

Sequence Value Average
formula
day #1 25 25 `= 25/1
day #2 5 15 `=30/2
day #3 3 11 `=33/3
day #4 6 9.8 `=39/4
day #5 13 10.4 `=52/5
day #6 10 10.3 `=62/6
day #7 12 10.6 `=74/7
day #8 25 12.4 `=99/8
and so on

thanks for any help

Gra
Click to expand...

Assuming that your data starts in A2, use something like this:
=AVERAGE($A$2:A2)

Then, drag down as far as needed. This will keep the first reference
to A2, not matter how far you take the formula down.
 
Back
Top