HARMEAN (First, Other...) HARMEAN (First; Other...)
First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
Number Number
The harmonic mean of the given values.
Returns the harmonic mean of the given values. The harmonic mean is the number of values divided by the sum of their reciprocals. It is the correct average for rates, such as speeds over equal distances. All values must be positive.
Examples
HARMEAN (2, 4, 4)
HARMEAN (2; 4; 4)
Returns 3.
HARMEAN (60, 40)
HARMEAN (60; 40)
Returns 48, the average speed of a trip driven at 60 km/h one way and at 40 km/h back.