Returns the geometric mean of an array or range of positive numeric data.
Syntax
GEOMEAN(number1, [number2], ...)Arguments
number1required
The first number or range of numbers you want to use.
number2optional
Additional numbers or ranges, up to 255 arguments.
The geometric mean is a measure of central tendency that is often used for data sets involving growth rates or compound interest. It is calculated by multiplying all numbers together and then taking the n-th root, where n is the count of numbers. Note that all values must be greater than zero.
=GEOMEAN(1, 3, 9)→3The cube root of (1 * 3 * 9) which is the cube root of 27, resulting in 3.
Select the cell
Click on the cell where you want the geometric mean result to appear.
Enter the function
Type =GEOMEAN( followed by the range of cells containing your positive numbers, then close the parenthesis.
The GEOMEAN function will return a #NUM! error if any value is less than or equal to zero.