Sunday, August 18, 2013

yogi_Calculate Monthly Subtotals Of Transactions By Category

                                          Google Spreadsheet   Post  #1338
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug, 18 2013
user cko (!category-topic/docs/spreadsheets/mSQmoJA8wIA)
How to calculate monthly subtotals of transactions by category
I'm trying to make a spreadsheet where I can enter in categorized transactions on one sheet and then have a second sheet that takes those transactions and adds up monthly subtotals for 
each category.

I've put most of it together in this example doc, but am not sure how to do the monthly and category sums on the second sheet.  Can anybody help with a working formula that does this?

Hopefully, this can be done in a way that is not hardcoded to a particular year so I could just duplicate to start tracking a new year.

Thanks in advance.

(let me know if you need write access)