In excel what formula to use that calculates the annual sales?

Answer 1

If you have previous figures to work from there are a few possible ways. You can use the FORECAST function if you have two sets of dependent figures. You could also use a standard formula if there is a pattern in the figures you have already have got. So if sales had gone up by 10% each year, you could increase the last sales you had by 10%. Forecasting is not always precise so to be accurate is not always certain, particularly with something like sales as it can be affected by many factors. So there are lots of functions that could be used.

Answer 2

That depends on how you have your sales organized. If you have monthly sales in C1 through C12, you would put =SUM(C1:C12) in cell C13 to show your anual sales.

Answer 3

Excel has the FORECAST function, but the quality of the forecast will depend on how well the data fit you model.