GEOMEAN Function

Returns the geometric mean of positive numbers.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice GEOMEAN in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

GEOMEAN multiplies n numbers and takes the n-th root. It's the right average for growth rates and ratios, because growth compounds.

For growth, average the growth factors (1.10 for +10%), then subtract 1.

Syntax

=GEOMEAN(number1, [number2], …)

Arguments

ArgumentRequired?What it does
number1YesA positive number, cell or range.
number2, …NoUp to 255 more.

Examples

Example 1 — Average yearly growth

Revenue grew 10%, fell 5%, then grew 20%. The simple average (8.33%) overstates it.

C2fx=GEOMEAN(B2:B4)-1
ABC
1YearGrowth factorAvg growth
220241.10.078365
320250.95
420261.2
=GEOMEAN(B2:B4)-1 Explain

Format as a percentage: 7.84% a year. Check: 1.0784³ ≈ 1.254, the same as 1.1 × 0.95 × 1.2.

Common mistakes

  • #NUM! A value is zero or negative. Convert returns like −5% to factors like 0.95 first.

Notes

  • For investment returns between two values, RRI gives the same compound rate directly.
  • Related functions: HARMEAN, AVERAGE, RRI.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.