Forum Discussion

Lawrence_Lam_320's avatar
Lawrence_Lam_320
Copper Contributor
Jul 19, 2023
Solved

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 ...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 19, 2023

    Lawrence_Lam_320 

    You can multiply the conditions:

     

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

SehrishFaiz8's avatar
SehrishFaiz8
Occasional Reader
Mar 06, 2025

HansVogelaarHi, 
I have used this formula. It works and counts unique value against critieria. However, if criteria one of the criteria doesn't match it gives 1 as value instead of 0. Could you please guide what error I am making?

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 06, 2025

    The error is in my formula, Change it to

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

Resources