Excel GEOMEAN function

Function              GEOMEAN

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

Syntax  GEOMEAN(number1, [number2], …)

number1  First value or reference.

number2  [optional] Second value or reference.

Example:

=GEOMEAN(4,5,2,3)= 3.30975091964687

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

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 GEOMEAN function.