Related Function:

The GEOMEAN function returns the geometric mean of an array or range of positive data.

Syntax

=GEOMEAN(num_1,[num_2], … )

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

Arguments

Argument Description
num_1 The first number, cell reference, or range for which you want the geometric mean
[num_2], … Optional. Additional numbers, cell references or ranges for which you want the geometric mean, up to a maximum of 255

Examples

  A B C D E F
1 Array1 Array2   Formula Result Notes
2 8 23   =GEOMEAN(A2:A9) 5.587767 Geometric mean of the data set contained in A2:A9
3 3 20   =GEOMEAN(A2:A9,B2:B5) 8.510038 Geometric mean of the data set contained in A2:A9 and B2:B5
4 5 15        
5 12 22        
6 3          
7 11          
8 2          
9 10          

Usage note: Use GEOMEAN to calculate average growth rate given compound interest with variable rates.

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied values cannot be interpreted as numeric values
#NUM! Occurs if any of the supplied values are negative

The geometric mean is a measure of mean that indicates the typical value of a set of numbers. This measure can only be used for positive values.

The equation for the geometric mean is:    

    \[    \text{Geometric Mean}_{\bar{y}} = \sqrt[n] {y_1 \times y_2 \times y_3 \cdots y_n}    \]

Note that the Harmonic mean is always less than or equal to the Geometric mean and the Geometric mean is always less than or equal to the Arithmetic mean.

See Wikipedia for more information on geometric mean.