Count unique names based on multiple criteria

Good Morning all,

I have a spreadsheet that contains the following function:

=COUNTIFS('Bonus Data'!$B$2:$B$464,"M",'Bonus Data'!$H$2:$H$464,"GB")

The resulting count is 300.

However when I manually count the names in $A$2:$A464 the answer should be 278, this is due to a number of peoples names appearing in A:A multiple times.

How can I amend the formula to return only the count of unique names?

Thanks in advance.

Andy

=sum(--(match("M",if('Bonus Data'!$H$2:$H$464="GB",'Bonus Data'!$B$2:$B$464),)=row('Bonus Data'!$B$2:$B$464)-1)) CSE

Tim,

Thank you for your speedy response but this gave me a #N/A response.

Andy

=sum(--(iferror(match("M",if('Bonus Data'!$H$2:$H$464="GB",'Bonus Data'!$B$2:$B$464),),)=row('Bonus Data'!$B$2:$B$464)-1)) CSE