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