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 only the amounts greater than zero in a single formula without having to modify the range of the formula every time I need the MEDIAN value of the amounts greater than zero dollars?

I used the MEDIAN formula applied to all ten values in the column and was returned a median value that didn’t return the correct value because 4 of the entries were zero dollars.  So, I adjusted the range in the MEDIAN formula for only the 6 entries that were greater than zero and it returned what I expected.  Is there a formula that would allow the MEDIAN to only consider values over 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 only the amounts greater than zero in a single formula without having to modify the range of the formula every time I need the MEDIAN value of the amounts greater than zero dollars? I used the MEDIAN formula applied to all ten values in the column and was returned a median value that didn’t return the correct value because 4 of the entries were zero dollars.  So, I adjusted the range in the MEDIAN formula for only the 6 entries that were greater than zero and it returned what I expected.  Is there a formula that would allow the MEDIAN to only consider values over zero$?  Read More

​