Hi

I am trying to get a forecast figure in excel and cannot figure out how to
do it. I have the following info

I have 8 months of sales to date with varying values. ie:
Jan 30 units, Feb 35 units, Mar 32 units, Apr 36 units, May 32 units, June
38 units, July 33 units and Aug 35 units.

Assuming it is 01 Sept and I do not have the figures for Sept - Dec yet I
have a year to date total of 271 units. The cells for Sept - Dec are
currently blank. I have 2 cells following after Dec. The first (Cell N2) is
YTD sales which is =Sum(B2:M2) or 271. The next cell (Cell O2) is where I am
having trouble. Given the sales so far to date I want to forecast what my end
of year sales will be. I want the cell to be able to update itself as I add
figures for Sept and Oct etc as I get them. I would imagine that the formula
should take an average of all the months, excluding those not filled in and
then use that figure to calculate and end of year sales forecast. I am
however having a lot of trouble figuring this out.

If anyone can help I would be most grateful.

Thanks

Jason