how do i set up a moving average in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

p-nut - 23 Oct 2006 17:55 GMT

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.

Reply to this Message

Bernard Liengme - 23 Oct 2006 18:27 GMT

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

Signature

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

>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.

Reply to this Message