More Spreadsheet Tomfoolery
I’m still messing around with my bookkeeping. Here is another nifty formula for OpenOffice Calc. I have a list of revenue and the dates that revenue was received like so:
| Date | Amount |
|---|---|
| 10 Jul 2009 | $1,080.00 |
| 18 Jul 2009 | $144.45 |
| 30 Jul 2009 | $2,248.40 |
| 2 Aug 2009 | $1,000.00 |
| 5 Aug 2009 | $522.30 |
I want to create a month-by-month summary of these figures. Here is the (rather complex) formula to make that happen:
=SUMPRODUCT(A1:A5>=DATEVALUE("01 Jul 2009");A1:A5<DATEVALUE("01 Aug 2009");B1:B5)
That formula will give the total of all amounts for July. By repeating this for each month, you can get monthly summaries for the whole year.