I use a budget sheet I developed over time (developing only by adding features, columns, lists etc. - I do not understand excel formulas or am not an advanced excel user).
I put my every spending in a sheet of the budget worksheet I use. On the top, the sum changes everytime I add a new spending.
But I have a problem - When I make a cash withdrawal from bank, I would like to put this on the same column too, to keep track of what I withdraw - only for information. But - this is not spent yet and I do not want the sum at the top not to change. The line of the column I make the withdrawal, of course always changes.
Is this something like possible? To make this cell not added to the automated sum at the top?
Something came to my mind - such as making an adjacent cell a dropdown menu and making options such as (credit card spending) (cash spending) (cash withdrawal) and when from the dropdown menu, "cash withdrawal" is selected, it might make the next cell " text value", not a number, so the number will not be added to the sum. Does this sound ok? Is there any way to do that?
Or - if not - Any other solution to what I try to accomplish?
Bookmarks