I am trying to calculate both an average and a median for a list of numbers.
I have zeros in the list which I want to keep in the average calculation but
need to ignore the zeros in the median calculation. Is there a way to write
that formula? Right now I have: =MEDIAN(N392:N1491)

I cannot simply sort by the column in question because I have serveal
columns that I have to do an average & a median for.

Any suggestions?
--
--coastal