vendredi 7 juillet 2017

Median If Equation on Excel file

I was trying to use Median with an If to find the median of a column for values greater than 0. This seems to be what I have seen others use; however, this formula does not seem to be correctly working for me. Does anyone seem to see the problem? Thank you!

=MEDIAN(IF(X3:X92 > 0,X3:X92))

Aucun commentaire:

Enregistrer un commentaire