HARMEAN function
Summary
Returns the harmonic mean
Syntax
HARMEAN(number1, [number2], ...)
The HARMEAN function syntax has the following arguments:
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas.
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example
=HARMEAN(A2:A8)