Author: Oscar Cronquist Article last updated on September 03, 2018

The GEOMEAN function calculates the geometric mean. It represents the typical value of a set of numerical values based on the product of their values. The AVERAGE function uses the sum to calculate the arithmetic mean.

Formula in cell D3:

=GEOMEAN(B3:B10)

Excel Function Syntax

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

Arguments

number1 Required. A single numerical value or a cell reference to multiple numerical values.
[number2] Optional. Upp to 254 additional arguments.

Comments

Text, logical values and empty cells are ignored.

The GEOMEAN function returns

  • #NUM! error value if number is less than 0 (zero).

Formula equation