Counting A Column Uniquely Based On Another Column

[Morie10]

I have a column (A) which I use check (ü) or false (û) ─ Wingdings font ─ to indicate whether people from column (C) are joined in group or not.

There are duplicates in the column (C), which I write people's names in, hence there are duplicate checks (ü) or falses (û) in column (A).

I want to count checks (ü) or falses (û) without duplicate, based on column (C); since obviously every checks (ü) or falses (û) would be duplicated multiple times because they have no distinction like names!

I already have a formula for counting column (C) without duplicate which I share below:
=SUM(IF(FREQUENCY(IF(LEN(a2:a497)>0,MATCH(a2:a497,a2:a497,0),""),IF(LEN(a2:a497)>0,MATCH(a2:a497,a2:a497,0),""))>0,1))

[#2 · Accepted solution]

@Morie10 

The attached workbook proposes two solutions: one using formulas, and the other using a pivot table whose source data have been added to the Data Model.

[#3]

It has worked! Thank you!

[#4]

Guys!
You can also use "(phrase)" in front of the (=) mark to avoid using an extra cell!

[#5]

@Morie10 

Yes, that is possible too. On the other hand, the extra cell makes it explicit what you're counting.