Returns the harmonic mean of the arguments.
HARMEAN(number1, number2, ... number30)
number1 to number30 are up to 30 numbers or ranges containing numbers. Numbers must not be zero.
The harmonic mean of is defined as.
HARMEAN(2, 4, 4)
returns 3, calculated as 3/(1/2 + 1/4 + 1/4).