Using the Excel GEOMEAN Function


The Excel GEOMEAN function returns the geometric mean of an array or range of positive numbers. To find the harmonic mean, use the HARMEAN function.


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

Syntax Breakdown

Number 1
Required. The first number for which you want to find the geometric mean. Entries can be an array or a reference in addition to numbers entered directly into the function and separated by commas.

The function will accept logical operators and text representation of numbers that are entered directly into the argument.

Number 2
Optional. Number 2 and subsequent number arguments are optional. The function can accept up to 255 arguments.

Usage Notes

GEOMEAN calculates the geometric mean. This is the average rate of return of a set of values calculated using the product of the terms. This shouldn't be confused with the arithmetic mean, which sums the values and divides by the total number of values.

Text, logical values, and empty cells in an array or reference are ignored. The function will include cells with zero values.

The function will return the #NUM! error if any data point is <= zero (0).