I have a basic question. In the attached, you can see I have a basic 3 columns. The cells should be self-explanatory I hope. For the 3rd column, the blank cells represent "Unpaid".
I would like a formula that says:
a) The sum that John has "Unpaid"
b) The sum that Mike has "Unpaid"
Below is how it looks in Excel, but doesn't quite work in Sheets
Can anyone help? Thanks.