Functions
HARMEAN
Harmonic mean
Try it
When to use it
When should I use HARMEAN instead of AVERAGE?
Use HARMEAN when averaging rates defined as ratios (such as speed or price-per-unit) where the denominator quantity is constant, because harmonic mean weights slower rates appropriately.
Used in
Syntax
HARMEAN(value1,...)Examples
=HARMEAN(1,2,3,4,5,6,7,8,9,10) // => 3.414171521474055
=HARMEAN(2,4,8) // => 3.4285714285714284
=HARMEAN(5,5) // => 5