title: COUNTIFS using multiple criteria in single formula
body: <p>Column A has <strong><code>Apples</code></strong>,<strong><code>Oranges</code></strong>, <strong><code>Pears</code></strong> multiple times.<br>
  Column B has the <strong><code>count</code></strong> against them (note, some of these may be blank).</p>
  
  <p>I'm looking for a formula to count just <strong><code>Apples</code></strong> and <strong><code>Oranges</code></strong> where their <strong><code>count</code></strong> is neither blank nor <strong><code>0</code></strong>.  </p>
  
  <p>I tried the formula below, but I get the count of <strong><code>Apples</code></strong> only:</p>
  
  <pre><code>=COUNTIFS(A1:A21,{"Apples","Oranges"},B1:B21,"&gt;0")
  </code></pre>