HARMEAN Function
Returns the harmonic mean of positive numbers.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
HARMEAN divides the count by the sum of the reciprocals: n ÷ (1/x₁ + 1/x₂ + …). It's the right average for rates over the same distance or amount — speeds, prices per unit, ratios.
The harmonic mean is always less than or equal to the geometric mean, which is less than or equal to the ordinary average.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A positive number, cell or range. |
| number2, … | No | Up to 255 more. |
Examples
Example 1 — Average speed for a round trip
A van drives to a depot at 60 km/h and back at 40 km/h. The average speed isn't 50.
| A | B | C | |
|---|---|---|---|
| 1 | Leg | km/h | Average speed |
| 2 | Out | 60 | 48 |
| 3 | Back | 40 |
Over 120 km the trip takes 1 + 1.5 = 2.5 hours, so 120 ÷ 2.5 = 48 km/h.
Example 2 — Average cost per unit
Spending the same $1,000 each month at $4, $5 and $8 per unit:
Returns about 5.22 — your real average price per unit.
Common mistakes
- #NUM! A value is zero or negative.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.