how do i set up a moving average in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to set up a 7 day running average and cannot figure out how to do
it? Any help would be greatly appreciated.
 
Hope I understand the Q
You have numbers in A1:A20 and will be adding more
In B7 enter =IF(ISNUMBER(A7),AVERAGE(A2:A7),"")
Copy down the column
This finds the average of the preceding seven numbers in A, provided there
is a value next to it
best wishes
 
Back
Top