GEOMEAN Function Explained
The GEOMEAN function in Microsoft Excel calculates the geometric mean of a set of numbers. It takes up to 255 arguments, which can be numbers, cell references, ranges, arrays, or constants. The geometric mean is the nth root of the product of n numbers, and is often used to calculate the average rate of growth or decline of a set of values.
GEOMEAN Function Syntax
GEOMEAN(number1, [number2], ...)
number1: The first number or range of numbers for which you want the geometric mean.number2: (optional) Additional numbers or ranges of numbers for which you want the geometric mean.