title: How do I avoid the "#DIV/0!" error in Google docs spreadsheet?
body: <p>I have a column with <code>average(K23:M23)</code> that starts out with <code>#DIV/0!</code> when the <code>K23</code> through <code>M23</code> cells are empty. Preferably I'd like to only do the average of cells that contain non-zero, non-blank values. I think it's possible using the query command:</p>
  
  <p><a href="https://docs.google.com/support/bin/answer.py?hl=en&amp;answer=159999" rel="noreferrer">https://docs.google.com/support/bin/answer.py?hl=en&amp;answer=159999</a></p>
  
  <p>But their example doesn't help me.</p>