Excel HARMEAN function

Function              HARMEAN

Description        Excel HARMEAN function returns the geometric mean for a set of numeric values.

Syntax  HARMEAN(number1, [number2], …)

number1  First value or reference.

number2  [optional] Second value or reference.

Example:

=HARMEAN(4,5,2,3)= 3.11688311688312

Which means =4/(SUM(1/4,1/5,1/2,1/3))

Usage Notes:

• Arguments are to be entered as numbers, names, arrays, or references that contain numbers.
• Empty cells, and cells that contain text or logical values are ignored in HARMEAN function.