Median

Hi, hope you can help me with a questions.



I have five number in five cells (in EXCEL). I have to calculate the median of them like 3,5,6,8 and 10 and the result of this should be 6, right.

Those numbers are results of other equation anda some times the value of one or two of them is #DIV/O or 0.

When the value is 0 I need to ignore 0 as a number like: 3,5,0,0,10. Because the result of thisp should be 5 without considering the 0. But with the 0 the result is 3.

I need the function MED ignore the #DIV/0 or ignore the 0 value.

Is that possible? Thank you much for your atention.