Checkbook Balancing - Credit and Debit in Same Columns

[ggoddard]

I am looking for some help with possibly using some kind of IF, SUM combination to work within a rudimentary checkbook spreadsheet I have set up.

Basically, I have always tracked Deposits and Debits in a single column, and used that to have a running "net account balance" total. I would like to start tracking my credit card using the same method.

excel.png

My current formula is =F814+A815 which calculates a credit or debit in A with my running balance in F.

I would like to put a credit card transaction in the same F column so I can keep track of a running total that includes expenditures on both cards the same way it does now.

However, you can see, that I use the checking account to PAY the credit card account, which is messing up my numbers. Is there anyway to just IGNORE the credit card payment (as it shouldn't affect my total since those pruchases were alraedy calculated) IF cell B equals a certain value?

Or am I going about this all wrong? My main concern is just continuing to enter all credits/debits the same way so it stays easy.

Thanks in advance!

[FDibbins]

Hi, welcome to the forum

Sounds like you need to include a test in that formula, using an IF() statement. Something like...

=if(B815="Credit Card",F814,F814+A815)