HARMEAN(number1 [,number2] [..])

Returns the harmonic mean of a data set.

number1The first number.
number2(Optional) The second number.


* The arguments must be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If any data point = 0, then #NUM! is returned.
* You can have a maximum of 30 arguments.
* For the Microsoft documentation refer to support.microsoft.com

1=HARMEAN(4,4,4) = 4.000
2=HARMEAN(5,5,5) = 5.000
3=HARMEAN(3,5,7) = 4.437
4=HARMEAN(4,5,6) = 4.865
5=HARMEAN(1,5,3,3) = 2.143
6=HARMEAN(-1,5,3,3) = #NUM!
7=HARMEAN(-1,"some text",3,3) = #VALUE!

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top