HARMEAN

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

Returns the harmonic mean of a data set.

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

REMARKS

* 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 255 arguments.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
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!