Because the harmonic mean tends toward the smallest values in a set of data, it limits the impact of large outliers, but exaggerates the impact of small outliers. The harmonic mean is always less than the geometric mean (GEOMEAN), which is always less than the arithmetic mean (AVERAGE). The HARMEAN function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. Often, a single range or array is used instead of multiple arguments, as seen in the example worksheet.
Examples
The average of 1, 2, and 6 is 3. The harmonic mean of 1, 2, and 6 is 1.8: In the example shown, the formulas in E5 and E6 are, respectively: Note that harmonic mean reduces the impact of the larger outliers in the data set.
Notes
Arguments can be numbers, names, arrays, or references that contain numbers. Empty cells, and cells that contain text or logical values are ignored.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
