title: Using COUNTIFS to find only unique values
body: <p>I currently have a table with five columns:</p>
  
  <pre><code>A = Campaign
  B = Person
  C = Opportunity Name
  D = Total Cost of Campaign
  E = Date
  </code></pre>
  
  <p>I'm trying to use COUNTIFS to count the number of rows that match the exact value in cell H2 to column A and has a date range, in column E, that is greater than the value in cell I2. </p>
  
  <p>I have something like this so far:</p>
  
  <pre><code>=countifs($A$2:$A, $H$2, $E$2:$E, "&gt;"&amp;$I$2).
  </code></pre>
  
  <p>However, I'm having a tough time to trying to dedupe this - it should only count unique rows based on the data in column C, where duplicate names exist. Please refer to my data table as reference:</p>
  
  <pre><code>Campaign    Person  Opportunity Name    Total Cost of Campaign  Date
  A           Bob     Airbnb              5000                   3/2/2017
  B           Jim     Sony                10000                  3/2/2017
  B           Jane    Coca-Cola           10000                  3/2/2017
  C           Jim     Sony                200                    3/2/2017
  B           Daniel  Sony                10000                  3/2/2017
  B           April   Coca-Cola           10000                  3/5/2017
  </code></pre>
  
  <p>For example:</p>
  
  <pre><code>=countifs($A$2:$A, $H$2, $E$2:$E, "&gt;"&amp;$I$2)
  </code></pre>
  
  <p>with <code>B</code> in H2 and <code>3/1/2017</code> in I2 will give me a result of <code>4</code> but I'm really trying to extract a value of <code>2</code>, given that there are only two unique names in Column C (<code>Sony</code> and <code>Coca-Cola</code>).</p>
  
  <p>How could I do this?</p>