median excluding 0's
One way
=MEDIAN(IF(A1:A50<0,A1:A50))
it's an array formula and needs to be entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
Portland, Oregon
"maryj" wrote in message
...
What formula would give the median of a range but exclude all 0's. Thanks!
--
maryj
|