I have a bunch of rows with a date and a dollar amount (expenses).
I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the list would be 8/5/2008 and the sum of all the expenses that occurred on or before 8/5/2008. Approximately this is
=sumif(D4:D30-A5,">0",E4:E30) but of course that doesn't work (where the source data is
D4:D30 and the
expenses are in
- source data can't be sorted for various reasons.
- must work in google spreadsheets, which is a fairly complete subset of excel's functions.