Thread: Budget Analysis

I am attempting to create a personalized budget spreadsheet but am stuck on one particular formula that I absolutely cannot figure out. Each bi-weekly period, I download all of my banking transactions from online & paste them into my own spreadsheet that I created. I have an added column where I have created a drop down list that houses all of my expense & income categories. For each transaction, I go through line by line & identify/select the related expense category & then this is where I am completely stuck.

I need a formula that will automatically calculate a running total of the dollar amount of EACH category in a table posted perhaps at the bottom of that particular tab.

I want each expense category to automatically update whenever a transaction is entered to align with it’s respective expense category. For example, if I enter a transaction that I then categorize as a ‘Car Maintenance’ expense, I want to car maintenance category to update with the dollar amount of that particular purchase.

HELP?*!!

Paste this formula in cell B2 on your RUNNING TOTALS sheet and copy down.

=SUMIF('Formula Test'!E:E,A2,'Formula Test'!C:C)