Google-sheets – Google Sheets Using Countifs & Unique Together

formulasgoogle sheetsgoogle-sheets-query

I am trying count the number of unique clients of Payroll service who are Won.

The answer as per the table below should be 4.

How can I achieve this, given that the table will be dynamic?

=COUNTA(UNIQUE(QUERY(A2:C; "select A where B='Payroll' and C='Won'"; 0)))

I know this is an old topic, but for the number of unique articles, this might work:

=ArrayFormula(counta(unique(filter(A2:A&B2:B, len(A2:A&B2:B)))))

I also tried to work out some formulas for the other questions:

enter image description here

Hope this helps ?

Assuming that A is in Cell A1, flag the rows in which you are interested with, in a spare column (E assumed), something like :

=(counta(A2:D2)=1)*1

copied down to suit. Count the rows in each column that are flagged and contain X with something like:

 =countifs(A1:A10,"X",$E1:$E10,1)

in ColumnA and copied cross to suit.