Practice free

GEOMEAN function

GEOMEAN returns the geometric mean of positive numbers by multiplying them and taking the root. Use it to average growth factors or ratios over several periods.

Example

Read it as a sentence: find the geometric mean of the numbers in A1:A8, which gives 4.603215596.

Practice this in the app

Syntax

GEOMEAN(number1, [number2], ...)

Arguments in [square brackets] are optional.

number1 (required)
First number, array or range.
number2 (optional)
Further numbers or ranges.

Returns: The geometric mean of the positive numbers.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=GEOMEAN({2,4,4,4,5,5,7,9}) 4.603215596 Array constant
=GEOMEAN(10,"20",TRUE) 5.848035476 Direct args: number, text-number, TRUE
=GEOMEAN(5) 5 Single number
=GEOMEAN({1,"2",TRUE,3}) 1.732050808 Array with text and boolean
=GEOMEAN(Data!A1:A8) 4.603215596 Range of numbers
=GEOMEAN(Data!B1:B8) 22.89428485 Mixed range: num, text-number, TRUE, blank, text, FALSE
=GEOMEAN(10,"abc") #VALUE! Direct arg: non-numeric text
=GEOMEAN({0,2}) #NUM! Contains zero

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • All values must be above zero or you get #NUM!.
  • For growth rates, use 1+rate as the inputs, then subtract 1.

Where it works

Excel
GEOMEAN is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .