HARMEAN Function in Excel – Calculate Harmonic mean in Excel

HARMEAN Function in Excel calculates the Harmonic mean of a supplied set of values.

The harmonic mean of a set of values x1, x2, …, xn is calculated by the formulaHARMEAN Function in Excel 1

 

Syntax of HARMEAN Function in Excel:

HARMEAN(number1, [number2], …)
  • Where the number arguments are a set of one or more positive values for which you want to calculate the Harmonic mean.

 

Example of HARMEAN Function in Excel:

Formula:

HARMEAN Function in Excel 2

  • Cells containing Text values, logical values, or no value are ignored by Excel HARMEAN Function.
  • Harmonic mean is calculated row wise in above example.
Result:

HARMEAN Function in Excel 3

Note :

 #NUM!  Error occurs if the supplied numeric values are negative.

previous HARMEAN Function in Excel                                                                                                                next HARMEAN Function in Excel