# HARMEAN

## Content

This function returns the harmonic mean of a data set.

## Syntax

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

## Arguments

<span data-teams="true">This function has these arguments:</span>

| <span data-teams="true">Argument</span> | <span data-teams="true">Description</span> |
| -------- | ----------- |
| *<span data-teams="true">number1, number2, ...</span>* | <span data-teams="true">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.</span> |

## Remarks

The harmonic mean is always less than the geometric mean, which is always less than the arithmetic mean.
The equation for this function is:
![](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-HARMEAN.png)

## Examples

`HARMEAN(F1:F9)`
`HARMEAN(R1C6:R9C6)`
`HARMEAN(35,31,47,51,37,31,58,39)` gives the result 39.2384929823