how do i set up a moving average in Excel
 

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.

how do i set up a moving average in Excel
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"p-nut" wrote in message
...
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.