title: Count Rows with Multiple Criteria
body: <p>I am going to count rows based on the values of two columns (i.e., count if the Priority is &quot;1&quot; and Status is &quot;not defined&quot;). Here is an example:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Priority</th>
  <th style="text-align: center;">Status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">implemented</td>
  </tr>
  <tr>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">implemented</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">not defined</td>
  </tr>
  <tr>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">not defined</td>
  </tr>
  <tr>
  <td style="text-align: center;">0</td>
  <td style="text-align: center;">implemented</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">not defined</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">implemented</td>
  </tr>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">implemented</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>which I would like to get 2 because there are only two rows with Priority = 1 and Status = &quot;not defined&quot;.</p>
  <p>I tried the following but not successful in this regard:</p>
  <p><code>=SUMPRODUCT((COUNTA(M3:M20))*(J3:J20=&quot;not defined&quot;))</code></p>