Monday, April 25, 2011

yogi_Calculate Monthly Spending

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

AndreasDK said:
I have just made this spreadsheet.
Dato for køb: Varens navn: Butik: Pris
14-04-2011 Merkur 42C kr 229
14-04-2011 Derby Extra skraberblade 10 stk kr 25
14-04-2011 Proraso 50ml barberskum Eucalyptus / menthol Gratis
14-04-2011 Forsendelse kr 39,00
19-04-2011 Floid Aftershave splash 150ml kr 81,66
19-04-2011 Semogue 1305 barberkost kr 104,33
19-04-2011 Forsendelse kr 37,29
TOTAL: 516,28

The field showing the Total amount uses =SUM(D4:D10), whisch is fine but I would like to show average monthly spending beneath that line.
Is there a function that can take the sum of =SUM(D4:D10) and divide it with the numer of months since creation of the sheet?

Please note that this spreadsheet's Locale is set to Denmark ... so ,(comma) is used for decimal instead of . (full stop) and ; (semicolon) is used as argument separator in functions