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.
- List of Statistical spreadsheet functions.