GEOMEAN Function in Excel – Calculate Geometric mean in Excel

GEOMEAN Function in Excel calculates the geometric mean of a supplied set of values.

The geometric mean of a set of values x1, x2, …, xn is calculated by the formula.GEOMEAN Function in Excel 1

 

Syntax of GEOMEAN Function in Excel:

GEOMEAN (number1, [number2], …)
  • Where the number arguments are a set of one or more positive values for which you want to calculate the Geometric mean.

 

Example of GEOMEAN Function in Excel:

Formula:

GEOMEAN Function in Excel 2

  • Cells containing Text values, logical values, or no value are ignored by Excel GEOMEAN Function.
  • Geometric mean is calculated row wise in above example.
Result:

GEOMEAN Function in Excel 3

Note :

 #NUM!  Error occurs if the supplied numeric values are negative.

previous GEOMEAN Function in Excel                                                                                                                next GEOMEAN Function in Excel