HARMEAN

The Excel HARMEAN function returns the harmonic mean for a set of numeric values. The harmonic mean is a kind of numeric average, calculated by dividing the number values in a list by the sum of the reciprocal of each value. In other words, the harmonic mean is the reciprocal of the average of the reciprocals. 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