SOLVED

# How to use count unique by using filter under multiple criteria from different colume

Copper Contributor

# How to use count unique by using filter under multiple criteria from different colume

Hi all expertises,

Last time, I learnt the following formula to count the unique by using filter under single criteria.

Formula is =count(unique(filter(A:A, B:B="correct"). The formula is correct and I can get the correct answer.

Now, I need to count the unique again but under multiple criterias from different columes. May I ask your help again? thanks

2 Replies
best response confirmed by Lawrence_Lam_320 (Copper Contributor)
Solution

# Re: How to use count unique by using filter under multiple criteria from different colume

You can multiply the conditions:

=COUNTA(UNIQUE(FILTER(A:A, (B:B="correct")*(C:C=37)*(D:D>25))

# Re: How to use count unique by using filter under multiple criteria from different colume

HI Hans, thank you so so much. I got the correct answer. Use * ( ) to add additional criteria. Thanks for your great help