View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default Rolling Average for Prediction


In Column A1:A12 enter Jan, Feb, Mar etc.
In Column B1:B12 enter your actual results say 10, 7 etc
In cell B13, enter =AVERAGE(B1:B12)

The answer will change as you add new data points for the future
months

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553165