title: Ignoring DIV/0! errors when calculating MEDIAN
body: <p>This may or may not be quite a simple one for the excel community. I have some data I wish to calculate the <code>MEDIAN</code> value for, and I'm using something similar to:</p>
  
  <pre><code>=MEDIAN(A1:A100)
  </code></pre>
  
  <p>This however spits back the following error:</p>
  
  <pre><code>Error: Function DIVIDE parameter 2 cannot be zero.
  </code></pre>
  
  <p>Which I assume is caused by cells containing the <code>DIV/0!</code> error. How do I allow excel to skip over such values? </p>