The Excel HARMEAN Function

Related Function:

The Harmonic Mean is a measure of mean that is calculated as the reciprocal of the arithmetic mean of reciprocals. This can only be calculated for positive values.

The harmonic mean of a set of values, y1, y2, ..., yn is therefore given by the formula:

Harmonic Mean Equation

Note that the Harmonic mean is always less than or equal to the Geometric mean and the Geometric mean is always less than or equal to the Arithmetic mean.

For further information on the harmonic mean, see the Wikipedia Harmonic Mean page

Function Description

The Excel Harmean function calculates the harmonic mean of a supplied set of values.

The syntax of the function is:

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

Where the number arguments are one or more positive numeric values (or arrays of numeric values), for which you want to calculate the harmonic mean.

In current versions of Excel (Excel 2007 and later), the function can accept up to 255 number arguments, but in Excel 2003 the function can only accept up to 30 number arguments. However, each argument can be an array of values or a range of cells, each of which can contain many values.

Harmean Function Example

  A B
1 2.5 =HARMEAN( A1:A5 )
2 3  
3 0.5  
4 1  
5 3  

Cell B1 of the above spreadsheet on the right shows a simple example of the Excel Harmean Function, used to calculate the harmonic mean of the values in cells A1-A5.

In this example, the Harmean function returns the value 1.229508197.

Further details and examples of the Excel Harmean function are provided on the Microsoft Office website.

Harmean Function Errors

If you get an error from the Excel Harmean function this is likely to be one of the following:

Common Errors
#NUM! - Occurs if any of the supplied numeric values are negative.
#VALUE! - Occurs if any of the supplied values are non-numeric.