Dear Experts,

I have a problem in counting unique value for any given criteria (in this case there are 2 criteria).

Count unique value with multiple criteria.JPG
The right table is what i expected to be the result.

From the table above, I want to count:
1. Number of car owned by every person with the Insurance Payment Date is blank.
2. Number of unique car brand owned by every single person with the Insurance Payment Date is blank.

You can download the excel file here.
shorturl.at/bcAGY


Thank you for your help.

Regards,
Erwin