I need a formula to calculate arrears payments on a spreadsheet
The sheet has a target payment for collection each week a payment column and
a remaining balance column weeks 1 to 52
I want the formula to count all arrears that are unpaid as a running total
can anyone help