Subtraction With Catagories

  • Hello everyone!


    I am new to the forums here and looking into learning more about excel/google sheets. I am currently working on a custom spreadsheet budget. I have a tab with my monthly expenses and I have another tab for my transactions. I would like to create an if statement/subtraction formula for the following. I would like to input a transaction and then choose a categories to go against. I then would like it to subtract for my monthly expenses tab. How would I do this? I have been searching the internet with no luck so far :(


    I know how to create categories/pull down list but just don't know how to make it subtract from my monthly expenses tab.


    I have attached a sample sheet to get my point across.


    Thank you!

  • I would suggest that you use Excel Built-in Tables, then this formula in the Actual Amount Column of the Expenses Table:


    =SUMIF(tblTransactions[Category],[@Category],tblTransactions[[Amount ]])


    Your sample file attached converted to Tables.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!