Excel HARMEAN Function

Using the Excel HARMEAN Function


The Excel HARMEAN function returns the harmonic mean of a set of values. The harmonic mean is defined as the reciprocal of the arithmetic mean of reciprocals. The HARMEAN function is useful when you need to calculate a mean that reduces the impact of outliers.


=HARMEAN (number1, [number2], ...)

Syntax Breakdown

Number 1
Required. The first number for which you want to find the harmonic mean. Entries can be an array or a reference in addition to numbers entered directly into the function and separated by commas.

The function will accept logical operators and text representation of numbers that are entered directly into the argument.

Number 2
Optional. Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments.

Usage Notes

HARMEAN calculates the harmonic mean, which is the reciprocal of the arithmetic mean of reciprocals. This shouldn't be confused with the arithmetic mean, which sums the values and divides by the total number of values.

The harmonic mean will always be less than the geometric mean (GEOMEAN), which is always less than the arithmetic mean.

Text, logical values, and empty cells in an array or reference are ignored. The function will include cells with zero values.

The function will return the #NUM! error if any data point is <= zero (0).