Hi all,
I want to find the median of a set of data but exclude any "0"s from the median calc, like I did with the "averageif" formula. Any ideas?

Thanks!

ex set of data
200
232
0
150
10
411
0