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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.