HARMEAN function

Description

Harmonic mean function. HARMEAN(range) computes the harmonic mean of the contents of the cells in the specified range.

The harmonic mean is calculated as follows:

The harmonic mean is undefined for a data set that contains zero or negative values.

Calculator

Related functions

List of Statistical spreadsheet functions.