Count unequal cells with condition IF

Hello:

I need formula like COUNTIF or COUNTIFS, but just for unequel cells, i.e count cells without count repeated cells.
if :
A1=3 B1=Joe
A2=5 B2=terry
A3=3 B3=Joe
A4=9 B4=Joe
A5=0 B5=terry

then the count of Joe should be =2 not 3.


Please check attachment worksheet.


Thanks

Please use an appropriate font in your posts.

One approach:

B2:
=SUMPRODUCT(--($B$9:$B$72=$A2);--(MATCH($A$9:$A$72&"@"&$B$9:$B$72;$A$9:$A$72&"@"&$B$9:$B$72;0)=(ROW($A$9:$A$72)-ROW($A$9)+1)))
copied down

On a final note - if (as it seems) the Site Name has a relationship of 1:1 with Region (ie a site name can never appear in more than one region) you could simplify to:

=SUMPRODUCT(($B$9:$B$72=$A2)/COUNTIF($A$9:$A$72;$A$9:$A$72&""))

the MATCH approach is only really required where the relationship is not 1:1 - ie a Site could appear in multiple regions.