Count unique text in colA with criteria in colB and colC

[yerffejqwerty]

Hello,

In column A I have animal names, some are duplicates.
In column B, each animal name has a different total value
In column C, each animal name has a percentage.

DOG...........50.....5%
CAT...........100....0.06%
CAT...........250....10%
MOUSE.......3.......1%
BIRD..........75......0.7%
DOG..........8........3%

I need a formula that will count unique animal names remaining after applying 2 criteria. Criteria 1: total value is above 10, criteria 2: percentage is above 2%.

Thanks!

 

[Weazel]

maybe something like...

A9=SUM(IF(FREQUENCY(IF(A2:A7<>"",IF(B2:B7>10,IF(C2:C7>0.02,MATCH(A2:A7,A2:A7,0)))),ROW(A2:A7)-ROW(A2)+1),1)) control shift enter

Row\Col	A​	B​	C​
1​	Name	Value	Percentage
2​	DOG	50​	5%​
3​	CAT	100​	6%​
4​	CAT	250​	10%​
5​	MOUSE	3​	1%​
6​	BIRD	75​	7%​
7​	DOG	8​	3%​
8​
9​	3​

<tbody>
</tbody>