title: Exclude 0 values from being averaged in Google Sheets
body: <p>When I try to use the <code>=AVERAGE()</code> function, Google Sheets  treats my empty cells as <code>0</code>. As a consequence, my calculated average value is wrong, see a <a href="https://i.stack.imgur.com/2dOnc.png" rel="nofollow noreferrer">sample</a>.</p>
  
  <p>Do you have a formula or any advice for this?</p>
  
  <p>I found the formula <code>=IF(EW171=0,"",EW171/EW108)</code>, but when I try<code>=IF(EW171:EW180=0,"",EW171/EW108)</code> it does not work. </p>