title: Clculate MEDIAN NA DIV/0
body: <p>The problem is I'm trying to use a build-in function MEDIAN() on a column to calculate median, whereas the cells contain #N/A and #DIV/0!. 
  I have tried to use IF statement such as <code>=IF(ISERROR(J:J), "", MEDIAN(J:J))</code> but it did not work. </p>
  
  <p>Similarly, when am calculating average, I found a perfect way which is <code>AVERAGEIF(J:J,"&lt;&gt;#DIV/0!")</code> to calculate mean. </p>
  
  <p>Such that I am looking for a similar function to solve this problem, as I don't want to use a loop, my data set is huge.</p>
  
  <p>Any help would be much appreciated!! </p>
  
  <p>Thanks! </p>
  
  <hr>
  
  <p>UPDATE:
  <code>ActiveSheet.Evaluate("GEOMEAN(IFERROR(IF($J:$J &lt;&gt; """",$J:$J), """"))")</code> the solution worked great, thanks guys! But what if I also want to void negatives and zeros in the formula?</p>