Excel GEOMEAN Function

The GEOMEAN function returns the geometric mean of an array or range of positive numbers. The geometric mean can be used for a set of numbers whose values are meant to be multiplied together or are exponential in nature, e.g., a set of growth figures.

Syntax

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

Arguments

Return Value

The GEOMEAN function returns a positive numeric value.

Function Notes

• Arguments can be numbers, arrays, or references that contain numbers.
• GEOMEAN ignores blank cells.
• If a text value is referenced by the GEOMEAN function, GEOMEAN will ignore it; If the text value is supplied directly to the GEOMEAN (e.g., =GEOMEAN(“kutools”)), the function will return the #VALUE! error.
• If a logical value is referenced by the GEOMEAN function, GEOMEAN will ignore it; If the logical value is supplied directly to the GEOMEAN, the function will treat is as a number (TRUE=1, FALSE=0).
• If any supplied values are not positive (≤ 0), GEOMEAN will return the #NUM! error value.
• If there are any error values in any of the arguments, GEOMEAN will return the first error value.
• The equation for the geometric mean is:
  
• √ Note: For more information about the geometric mean, please view the Wikipedia Geometric Mean Page.

Example

Supposing you have a table with numbers as shown below, to get the geometric mean of the numbers, please copy or enter one of the formulas below in a blank cell, and press Enter to get the result:

=GEOMEAN(5,2,1,11,11,8,50,50,1.5,5,6.5,9,4)

=GEOMEAN({5,2,1;11,11,8;50,50;1.5,5;6.5,9,4})

Or, use cell references to make the formulas dynamic:

=GEOMEAN(B3:D7)

=GEOMEAN(B3:B7,C3:C7,D3:D7)

Related functions