GMEAN, GEOMEAN

Syntax:	GMEAN(argumentlist)
	GEOMEAN(argumentlist)

argumentlist = any combination of numbers, cells, or ranges with each of the values greater than 0

GMEAN returns the geometric mean of its arguments. Blank cells and cells containing strings are not included. The function is given by:

$$\sqrt[n]{\prod_{i=1}^N a_i}$$

GEOMEAN is a synonym for GMEAN.

Examples:

GMEAN(56, 49, 99) = 64.76491

GEOMEAN(F10..F14) = 3.4712517, where F10..F14 = 2, 2, 3, 6, and 7

GMEAN(U7..V15) = Error - GMEAN, operand less than or equal to zero, where U13 = 0

Excel function: GEOMEAN