Forum Discussion
Solved
Median of a column of all numbers in the column that are greater than zero
I have a column of 10 dollar amounts. A certain number of those cells are filled with dollars over zero; the remainder, if any, are always filled with zero dollars. How can I find the MEDIAN of onl...
=MEDIAN( IF( A1:A10 > 0, A1:A10) )this assumes you run Excel >/= 2021 and A1:A10 contains Numbers only
=MEDIAN( IF( A1:A10 > 0, A1:A10) )
this assumes you run Excel >/= 2021 and A1:A10 contains Numbers only