title: count rows in excel with multiple matched criteria
body: <p>I have the following data in a excel sheet and would like to count the number of rows that match specific criteria.</p>
  
  <pre><code>   A      B        C
  1  Name   Status   Version
  2  Joe    Open     1.0
  3  Bob    Open     1.0
  4  Joe    Closed   1.0
  5         Open     1.0
  6  Joe    Open     2.0
  </code></pre>
  
  <p>I would like to count all rows where;</p>
  
  <ol>
  <li>Name is not empty, AND</li>
  <li>Status is not "Closed", AND</li>
  <li>Version is not "2.0"</li>
  </ol>
  
  <p>based on the sample data above the count would be 2 (row 2 and 3 on the sheet)</p>
  
  <p>How could I achieve this?</p>
  
  <p>Thanks in advance.</p>