HARMEAN Function

Returns the harmonic mean of positive numbers.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice HARMEAN in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=HARMEAN(number1, [number2], …)

Arguments

ArgumentRequired?What it does
number1YesA positive number, cell or range.
number2, …NoUp 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.

C2fx=HARMEAN(B2:B3)
ABC
1Legkm/hAverage speed
2Out6048
3Back40
=HARMEAN(B2:B3) Explain

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:

=HARMEAN(4,5,8) Explain

Returns about 5.22 — your real average price per unit.

Common mistakes

  • #NUM! A value is zero or negative.

Notes

Kyle Stott

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.