title: Average from 5 cells if not blank or zero
body: <p>I need to calculate an average of 5 cells, but if a cell is blank or zero, it should neglect this value. </p>
  
  <p>I am not able to get it to work with </p>
  
  <pre><code>=AVERAGEIFS(A10;B13;C5;D6;D8;"&lt;&gt;0")
  </code></pre>
  
  <p>Does anyone know the correct way to calculate this? </p>