Looking to build a running balance spreadsheet

[ShuckleLvX]

Hey folks!

I've been out of the excel game for the past 6 years (a long time when you're 27!) and am trying to do something I'm utterly convinced would have taken me seconds back in my day, but now I'm totally bamboozled.

I'd like to make a quick reference sheet for accounts, tracking only the running balance in the account (I'll have detailed records showing how to get to that number if necessary, so I only need to have excel recall the final amount.)

How I'd like it to work would be three cells (A1, A2, A3). A1 and A2 are blank, to have Deposits and Withdraws (respectively) entered. A3 would be the balance.

Ideally, you'd enter a deposit into A1 (say, $200), it would disappear, and A3 would be increase by $200 ($100->$300). Then enter a withdraw into A2 (say, $150), it disappears from the cell and A3 is reduced by $150 ($300->$150). Hopefully this is making sense to someone.

Any thoughts? I'm fumbling around blind, feeling as if I've never used this program before >.<

[FDibbins]

Hi, welcome to the forum

Just to make sure I understand...

you enter 200 in A1
C3 shows 300 - previos 100 + current 200
you remove the value from A1 - A1 now is empty
C3 still shows 300
etc

If that is what you want, that cannot be done with formulas, you would need to use VBA (coding) for that

[lazyme]

This concept is similar to having database which can be done in Excel if you keep a record of all the transaction.
1. You build a separate sheet with all your transactions with a label for Debit and Credits.
2. On your [Summary] page, you just calculation your balance based on Debit and Credits.