google sheets budget formulas for debt tracking
I'm very rusty with sheets and excel so I'm not sure if what I'm trying to do is even possible (can't really imagine that it isn't for excel) or if there's an easier way to go about this? I'm trying to formulate a debt tracker for my various accounts and I can't seem to get the concept I'm looking for into a valid formula. I have two worksheets; Worksheet 1 is called 'Trans' for transactions and Worksheet 2 is called 'Plan'.
In 'Trans', column A has values that represent either a payment or a charge to the account and column B has data validation to determine whether the value in column A is a Charge or a Payment.
In 'Plan', cell C1 holds the account max limit and cell D1 is the To-Date total I've acquired in comparison to C1.
What I'm looking for is a way to add and subtract the values in 'Trans'A based on their status of Charge or Payment determined in 'Trans'B, from 'Plan' C1 so I have a live look at my total debt on the account. Basically what a banking app does for you live, but I'm trying to combine multiple banks and accounts into a spreadsheet.
Or! If there was a way to apply conditional values of + or - to Column A based on the Data validation from Column B, I guess I can just use SUM across worksheets to add them. That seems farm more simple to me, but applying the conditional values based on the data validation is what is catching me.