Seems should be simple to have a bank balance increase each month and, in one cell, have a running balance of the “increases only” as I enter the larger numbers each month.
I don’t know how your spreadsheet is configured, if the following doesn’t help, then please upload (up-pointing arrow icon) a sample.
To keep a running balance, add credits and subtract debits.
RandomDebitCredit.ods (30.6 KB)
Or do you want to ignore debits? Try =SUMIF(B2:G2,">0")
1 Like