C
coastal
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?
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?