Formula that counts number of unique text values if it meets criteria

I have been using this function to count the number of unique text values in a data set:
=SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1))

It works great if I want to count number of unique text values overall. However, I want to count the occurences of unique text values if they meet specific criteria. (Like a countifs function would if it could count unique text).

Any ideas?

It is text criteria:
Criteria Range: Table[Last Name, First Name]
Criteria: "Last Name, First Name"

It is based in the context of how many active employees (unique text values) fall under so-and-so's team (my criteria).

It works! Thank you so much!

Tony
How would you modify this formula to look at the criteria in a 2nd column on top of looking in Column A?
I have a list of people with different certifications that work in different regions. I am currently using your example to give me a count of people per region and it removes the duplicates perfectly.
=SUM(IF(FREQUENCY(IF(('CMD Certs'!$C$2:$C$20000=$A16),MATCH('CMD Certs'!$A$2:$A$20000,'CMD Certs'!$A$2:$A$20000,0)),ROW('CMD Certs'!$A$2:$A$20000)-ROW('CMD Certs'!$A$2)+1),1))

I can modify it to give me a count of people with a certain type of certification and that works well too.
=SUM(IF(FREQUENCY(IF(('CMD Certs'!$E$2:$E$20000=H$15),MATCH('CMD Certs'!$A$2:$A$20000,'CMD Certs'!$A$2:$A$20000,0)),ROW('CMD Certs'!$A$2:$A$20000)-ROW('CMD Certs'!$A$2)+1),1))

But I need it to give me the count of personnel within a region with a specific type of certification. How can I get both in a single statement

Thanks in advance
George