Syntax. GEOMEAN(number1,number2,...)

Definition. This function returns the geometric mean of a set of positive numbers. For example, you can use GEOMEAN() to calculate the average growth rate for an interest calculation with variable rates.

The geometric mean is calculated as the n-th root from the product of all values where n is the number of values.


  • number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the geometric mean. You can also use a single array or a reference to an array instead of arguments separated by commas.


Arguments can be numbers, names, arrays, or references containing numbers.

If an array or a reference argument ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.