Excel functions / Statistics

HARMEAN function

The harmonic mean: the right average for rates such as speeds.

Syntax

=HARMEAN(number1, [number2], …)

Arguments

When to use it

HARMEAN gives the harmonic mean: the count of values divided by the sum of their reciprocals. It is the right average for rates over the same distance or amount, such as speeds over equal legs of a trip.

Examples

  1. Average speed out at 60 and back at 40

    ABC
    1Speed
    26048
    340

    In C2: =HARMEAN(A2:A3) → 48

    Not 50: more of the trip's time was spent at the slower speed.

    Try this example

Common mistakes

HARMEAN in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try HARMEAN in the playground

Related functions