Median without including zeros

[elsmith9035768]

I am trying to calculate the median of a string of numbers. Sometimes zero will be included in the string, but I don’t want any zeros included in the median value. I’ve included an example. In the example, I need the median of C3 through C14. It should be $374,750 (E3) but is showing as $368,750 (C1) because the zero is included in C1. What is the formula I need in C1? Thanks!

 

[Nebu]

Hi:

Try the following formula
=MEDIAN(IF(MMULT(($C$3:$C$14)*($C$3:$C$14),1)>0,$C$3:$C$14))

Thanks

 

[azumi]

hope this work

 

[Hui]

=MEDIAN(IF(C3:C14>0,C3:C14)) Ctrl+Shift+Enter

 

[elsmith9035768]

Both work. Thanks!

 

[bosco_yip]

Non-CSE version similar to Nebu's :

=MEDIAN(IF(MMULT(0+C3:C14,1)>0,C3:C14))

Regards
Bosco