Returns the harmonic mean of a data set.
HARMEAN(Number1; Number2; ...; Number30)
Number1, Number2, ..., Number30 are up to 30 values or ranges, that can be used to calculate the harmonic mean.
=HARMEAN(23;46;69) = 37.64. The harmonic mean of this random sample is thus 37.64