Monday, April 25, 2011

yogi_Calculate Average Amount Per Month ToDate Starting A Specified Month

Yogi Anand, D.Eng, P.E.                                   Google Spreadsheet                      www.energyefficientbuild.com
AndreasDK said:
I would like a line sayng something lake "Monthly average buy sum", which looks at the dates for the purchases and divides TOTAL out with number of months from the start of the spreadsheet (April 2011) to the current month.

So that if I buy something next month for the price of kr. 1 (see example in document) the Monthly average sum would say 517,28 / 2 (April and May 2011).
Should I not buy anything in June no entry would be made with a date in June bout Average monthly sum should still include the month, so that it says 517,28 / 3 (April, May and June) as these months have passed since the start of the spreadsheet.

------------------------------------------------------------------------------------
In the following solution I have generalized it by specifying the StartingMonth in cell B4