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

Copper Contributor

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)


You can multiply the conditions:


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

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