title: Count if value is lower than 80 and equal or bigger than 0 but not empty
body: <p>I'm trying to countif some values but not the empty ones this is my formula and this is the data that I try to count:</p>
  <pre><code>=COUNTIF(B2:B15,&quot;&lt;0.8, &gt;=0&quot;)
  </code></pre>
  <p>But this formula counts the empty one too, I would like to have only one like in the image in colum b should be count only 2 but it count 13.</p>
  <p><a href="https://i.stack.imgur.com/bfzcB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bfzcB.png" alt="enter image description here" /></a></p>