title: Excel CountIFs with 2 different conditions
body: <p>I need to count with the following conditions:</p>
  
  <ul>
  <li>dates (Range: Incidents!C2:C300) > 1/1/2012</li>
  <li>Categories(Range: Q2:Q300) matches Sheet2!B2:B8</li>
  </ul>
  
  <p>Currently, I have the following formula and is working:</p>
  
  <pre><code>=Countifs(Incidents!Q2:Q300,Sheets2!B2:B8)
  </code></pre>
  
  <p>This formula simply count the number of records that are, for example, related to logins</p>
  
  <p>However, when I do</p>
  
  <pre><code>=Countifs(Incidents!Q2:Q300,Sheets2!B2:B8, Incidents!C2:C300, "&gt;1/1/2012")
  </code></pre>
  
  <p>I got a <strong>#VALUE</strong> error on my cells</p>
  
  <p>How can I do this ? I need to filter out records that are before 2012.</p>
  
  <p><strong>Update:</strong></p>
  
  <p>Data type on Incidents!Q2:Q300: Text
  Data type on Sheets2!B2:B8: Text
  Data type on Incidents!C2:C300: custom, "dd-mmm-yy h:hh:hh"</p>
  
  <p>Below is the actual code I used that got me the #VALUE error</p>
  
  <pre><code>=COUNTIFS(Incidents!$Q$2:$Q$300,Sheet2!B5,Incidents!C2:C300,"&gt;1/1/2012")
  </code></pre>