MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula for expenditures


Posted by Al on January 27, 2002 6:04 PM

I am using this formula supplied by Barrie to average columns Jan. thru Dec. =ROUND(SUM(B8:M8)/COLUMNS(B8:M8),2) What I need is a formula to estimate what my total expenditure might be for 12 months at the rate of expenditure Year to date.


Posted by Barrie Davidson on January 27, 2002 6:28 PM

Al, try this.

=ROUND(SUM(B8:M8)/COUNT(B8:M8)*12,2)

Regards,
BarrieBarrie Davidson

Posted by AL on January 27, 2002 6:40 PM

Posted by AL on January 27, 2002 6:42 PM