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

[Lawrence_Lam_320]

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 · Accepted solution]

@Lawrence_Lam_320 

You can multiply the conditions:

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

[#3]

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