GEOMEAN function
Summary
Returns the geometric mean
Syntax
GEOMEAN(number1, [number2], ...)
The GEOMEAN function syntax has the following arguments:
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas.
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example
=GEOMEAN(A2:A8)