Calculates the harmonic mean of a dataset.
Sample Usage
HARMEAN(1,2,3,4,5)
HARMEAN(A2:A6)
Syntax
HARMEAN(value1, [value2, ...])
- value1 - The first value or range to consider while calculating the harmonic mean value.
- value2, .. - [OPTIONAL] Additional numbers or ranges to consider.
Examples
HARMEAN(1,2,3,4,5) returns a value of 2.1897.
HARMEAN(A2:A6) returns the harmonic mean of the numbers in cells A2 through A6.