How do I work out an average spend?
May 21, 2009 12:07 PM Subscribe
ExcelFilter: I want to calculate an average food spend, but the days I buy food are irregular throughout the month. How can I draw up a table/graph that gives an average based on a date and amount (for OpenOfficeCalc)?
posted by Gisela to Work & Money (11 answers total) 1 user marked this as a favorite
My best idea was to divide each spend by the days in between, but surely there is a better way to do this?
I'd like to end up with a graph with the date along the bottom too, but even that defeats me.
Please hope me!