Hi all, I have a purchase invoice spreadsheet (Invoice details in columns A-G). In columns H & I, I enter the payment details. At the bottom of column D is a total.

I would like this total to only include unpaid invoices. I have entered an IF function +IF(H98>0,0,D98) i.e., if column H has a payment date then don't include this invoice in the total. This works, but I can't see how to replicate it for each invoice without copying it each time I enter a new invoice.

Can anyone help please?

Many thanks