View Single Post
  #2   Report Post  
Bruce Gray
 
Posts: n/a
Default

Just to clarify, below is a section of the spreadsheet.
What I want to do is create subtotals for each month for the vehicle column.
However, I don't know how to do this with the functions. Specifically how to
select values that correspond to a certain date range.

Any help appreciated.



Date Acct Details cat. Code Amt inc gst gst bus. component Vehicle .80
bus.
01/07/04 MC Dodo Internet internet 23.90 1.88
02/07/04 MC Independ Fuel Supplies Brenndale vehicle 17.05 1.13 12.40
05/07/04 cdia Martin S Iga Sprmkt Samford Au 039523 private use 213.06
08/07/04 cdia Withdrawal 4185 invested 8,000.00
08/07/04 MC Caltex Lawnton vehicle 27.67 1.83 20.12
08/07/04 MC Qld Transport Strathpine vehicle 62.30 4.12 45.31