Count Unique with IF

[anj]

Hey, I am trying to count the unique number of entries within an array. I know that I can use Frequency, Match and Sum to count the number of unique entries in a column, but can an if statement be added? For example in the table below: Can I count the unique number of DOG names only? And therefore not include the cat entries. So unique entries would be (3) in this case, rather than (5).


Type Name
dog henry
cat fur
dog henry
dog rex
dog suzie
cat tuna


Thanks!

[daddylonglegs]

Here's one way

=COUNT(1/FREQUENCY(IF(A2:A7="dog",MATCH(B2:B7,B2:B7,0)),ROW(B2:B7)-ROW(B2)+1))

confirmed with CTRL+SHIFT+ENTER