title: Google spreadsheet - Case sensitive COUNTIFS
body: <p>I'm using countifs to find all rows that match certain criteria's, but it doesn't work. Some example rows:</p>
  
  <pre><code>abc     abc    6542543
  abc     Abc    
  def     Def    43243
  def     def    12344322
  </code></pre>
  
  <p>I need to count all rows where the first column is the same, the last column is NOT the same and the third column is NOT empty. In this example, that would yield 1 for all rows except the first.</p>
  
  <p>These are my formulas and expected outcomes:</p>
  
  <pre><code>=countifs(A$1:A,A1,B$1:B,"&lt;&gt;"&amp;B1,C$1:C,"&lt;&gt;")    0
  =countifs(A$1:A,A2,B$1:B,"&lt;&gt;"&amp;B2,C$1:C,"&lt;&gt;")    1
  =countifs(A$1:A,A3,B$1:B,"&lt;&gt;"&amp;B3,C$1:C,"&lt;&gt;")    1
  =countifs(A$1:A,A4,B$1:B,"&lt;&gt;"&amp;B4,C$1:C,"&lt;&gt;")    1
  </code></pre>
  
  <p>However, it yields 0 everywhere. This is because countifs works case insensitively. How do I solve this to be case sensitive?</p>