Hey everybody,
I was wondering if anyone out there can help me with this scenario. I am trying to keep a running account balance on a created spreadsheet done in this format. If you have a better template or other examples I would be greatly appreciative.
Thanks you!!
Paul
MacBook Air 13", macOS 10.14
You can try something like this:
In G3, filled right and down:
=SUMIFS($F$2:$F3,$E$2:$E3,G$2)
For this to work, you need to enter additions to Checking as positive, outflows from checking as negative. And enter a transfer from Checking to Savings twice, once positive once negative.
Substitute ; for , in the formula if your region uses , as a decimal separator.
SG
You can try something like this:
In G3, filled right and down:
=SUMIFS($F$2:$F3,$E$2:$E3,G$2)
For this to work, you need to enter additions to Checking as positive, outflows from checking as negative. And enter a transfer from Checking to Savings twice, once positive once negative.
Substitute ; for , in the formula if your region uses , as a decimal separator.
SG
Hi SG,
Thats great. Just a couple more things if you don't mind then Im almost done. First Is it possible to have on the bottom of the column showing an account "balance" reflecting the addition or deduction to the account? Also under the column Transaction could I have the Debit or Credit option reflect a deduction or addition in "Check" column?
Thanks!!
budgeting spreadsheet
