Assuming data s shown below in columns A to C then in C2 put:

=IF(B2<"",B2,SUM($B$2:B2)/COUNTA($B$2:$B$16))

and copy down



Actual Prediction
Jan 10 10.00
Feb 5 5.00
Mar 9 9.00
April 8.00
Apr 8.00
May 8.00
Jun 8.00
May 8.00
Jul 8.00
Aug 8.00
Sep 8.00
June 8.00
Oct 8.00
Nov 8.00
Dec 8.00

HTH


"DangerMouse" wrote:


Hi all,

I'm hoping and anticipating that theres a really simple solution to
this question but I can't seem to get my head around it. Any advice you
could provide would be much appreciated.

I'm simply calculating hit rate, or average on a monthly basis, and I
want this data to inform future months in a predictive fashion.

Thus I have 10 in Jan, 5 in Feb, my avarage is obviously 7.5, thus I
would like all months after Feb to predict the "hit" figure to be 7.5.


I would like this to work on a rolling basis as evidently as the actual
figures are available the average changes and thus so does the
prediction.

I appreciate this isnt the most scientific way to model things but any
assistance would be appreciated.

Thnx


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