title: Excel find Median from non contiguous cells and ignore 0 values
body: <p>I've got a complex Excel sheet and want to find median on different cells which are scattered for example <strong>A1, C1, G1, X1, Z1 etc.</strong> and want to Ignore Cells having 0 values so that these 0s cant be counted in <code>median</code>, any idea how I can do it?</p>
  
  <p>The following function can do this But the problem is: it counts 0 as well, is there any way to modify this formula to ignore 0s</p>
  
  <pre><code>MEDIAN(A1,C1,G1,X1,Z1)
  </code></pre>