I have a budget spreadsheet to track my personal, non-bill spending. I try to keep certain categories within certain dollar amounts. I have created a column to categorize my transactions that has drop downs.
For example, I allot $50/month for Lunch. I would like to create a second part of my spreadsheet where starting with $50, if column C has Lunch, deduct amount from Column F from starting value. Then it pull every time a row has "Lunch" in the drop down.
I have tried using this thread: subtract from number IF statment
But I don't think my situation exactly applies.