title: Correct Way To "COUNTUNIQUE" That Only Counts Once
body: <p>I am trying to count the unique values of a column, based on their status in another column, example:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customers</th>
  <th>License Active</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Adam</td>
  <td>Yes</td>
  </tr>
  <tr>
  <td>Barry</td>
  <td>No</td>
  </tr>
  <tr>
  <td>Adam</td>
  <td>No</td>
  </tr>
  <tr>
  <td>Claire</td>
  <td>No</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>In this situation, I want to know how many customers have at least 1 active license, and how many customers do <strong>not</strong> have at least one active license.</p>
  <p>The formula I have tried is:
  <code>=COUNTUNIQUEIFS(A2:A,B2:B,&quot;Yes&quot;)</code>
  This returns <code>1</code> in this situation which is correct, as there is 1 customer who has a Yes on column B.
  My issue is when I try to do the reverse, count the &quot;No&quot; using this formula:
  <code>=COUNTUNIQUEIFS(A2:A,B2:B,&quot;No&quot;)</code> it returns <code>3</code> which is not the desired result as it is counting the second <code>Adam</code> as a unique value too because they have a &quot;No&quot; in column B.</p>
  <p>The result I want here is <code>2</code>, because Adam has a yes somewhere in column B so I don't want him counted again the next time his field is counted.</p>