Skip to Content

HARMEAN

Returns the harmonic mean of a data set of positive numbers

Syntax

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

Parameters

  • number1: Required. The first argument
  • number2: Optional. Additional arguments, up to 255

Example

=HARMEAN(A1:A10)
Returns: NumberSince: Excel 2003