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
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A positive number, cell or range. |
| number2, … | No | Up 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
| A | B | C | |
|---|---|---|---|
| 1 | Year | Growth factor | Avg growth |
| 2 | 2024 | 1.1 | 0.078365 |
| 3 | 2025 | 0.95 | |
| 4 | 2026 | 1.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.

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.