Moving Average question for a newbie
Posted by RGE on February 02, 2002 5:50 PM
How do I calculate a 3 day moving average that continually changes when new numbers are added to the column?
a1:Date b1:Cost c1:3day moving average cost
a2:1/1/2002 b2:10 c2: EXCEL FORMULA
In this example, C2 should be 11.6666. Lets say my cost number for 1/5/2002 is 10. When I enter 10 into b6, I would like C2 to change to 13.333 ((10+20+10)/3).
This is probably too simple for this board, but I'm drawing a blank...
Thanks in advance...