I need a formula that totals 12 cells in a row ( the row is monthly sales)
for an annual total.

However if the row doesn't have a full 12 months worth of data I need to
estimate the annual sales by taking an average of the available months and
multiplying them by 12.

(the available months will vary on each row- some may have only the first 3
months or 7 months etc)

Thanks for any help on this.






--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003