Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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)))
Required, but never shown