Hello. I am making a budget spreadsheet, and would like to add a simple way to have the spreadsheet add up how much was spent each month for each category, based on downloaded account history.
Please refer to the attached spreadsheet.
Budget example.xlsx
What I would like to do, is paste each month's account history into a new tab of the spreadsheet (for example, "Jan2013 Acct Hist" as seen in the spreadsheet), and add a column to the left to designate which budget category applies to each transaction. Then, I would like a formula (for example, in cell M7 of the "Expenses 2013" sheet) to add up all of the transactions that match that cell's month and category designation in the account history sheet.
I hope this isn't too confusing, but please feel free to ask if you need clarification on anything.
Thank you in advance for your help.
Andrew
Bookmarks