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.