One simple way
Assume monthly figs are progressively entered in B2 across
In C2: =AVERAGE($B2:B2)*12
Copy C2 across to return desired yearly forecast
High-five? Click YES below
P/s: Rather than here, post such questions in excel.worksheet.functions
which is a more appropriate and better attended newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"JanSanM" wrote:
I am keeping a log of cases done per month, and need to annualize each month
to forecase yearly volume. I am looking for the way to build the formula to
Annualize.