Countif only unique value in a specific time range

Hi everyone,

Thanks in advance for your help. This might be a very simple one for some, but I'm having difficulty to make this automatic.

https://docs.google.com/spreadsheets...it?usp=sharing

As you can see from the sample excel, you will have dates in Column A and names in Column B.

I want to count only "unique names" that are either in "Yes" or "in progress" on column C on a weekly basis starting Dec, 30, 2019 (refer to the table on the right side). Between 12/30/2019 and 1/5/2020, there are 6 lists, but only are only three unique names, but only Brian and Jenny are meeting the condition for Column C so I want to only count 2.

* a bit more detail on what I'm trying to count here - I have a list of customers that frequently visit and make purchases. I want to identify the actual customers that are willing to pay on a weekly customers.

Let me know if you need any further clarification.
Thanks!

Perhaps this will be of some help although it is written for Excel.
1. A list of distinct names is produced using: =IFERROR(INDEX(B$2:B$32,MATCH(0,INDEX(COUNTIF(Q$2:Q2,B$2:B$32),,),)),"")
2. Those names meeting the criteria of "Yes"/"In Progress" and appropriate dates are counted using:

Formula:

Please Login or Register  to view this content.

3. An overall count for the week is made using: =COUNTIFS(R3:R14,">0")
Let us know if you have any questions.