Zoho Sheet GEOMEAN Function: Geometric Mean and Growth Examples

GEOMEAN(number; [number1]; ...)

Argument: number

Required
Yes

Description
Numeric value, numeric cell, or range whose geometric mean is needed.

Example
A2:A5

Argument: [number1]` and subsequent arguments

Required
Optional

Description
More numerical values, cell references or ranges to include in the same geometric mean.

Example
C2 or B2:B8

The semicolon is the delimiter printed by Zoho’s English-language function documentation. For instance, the official page shows =GEOMEAN(1;2;3;4;5) and displays 2.605171085, matching the independent mathematical calculation. The general reference also lists examples involving a mix of literal numbers and cell references, but their exact outputs depend on the embedded sample-sheet data.

Use a colon inside a range such as A2:A5; a range is one argument, not four manually separated cell addresses. Argument separators can differ when importing formulas into another spreadsheet or using locale-specific notation. Do not blindly copy a comma-separated Excel formula into a Zoho worksheet without checking how that workbook interprets separators.

Availability: This is an identified built-in function in the current Zoho Sheet online statistical-function catalogue (inventory dated October 11, 2026; reference checked October 12). No first-supported release, historical account entitlement or device-by-device capability is documented in that reference. Zoho has announced beta Windows and macOS desktop apps, but that announcement is not a native test of this function in those apps.

Enter the following numbers with a header so the formulas are reproducible:

1. Select an empty cell, such as C2.
2. Enter =GEOMEAN(A2:A5) and confirm it in Zoho Sheet.
3. The predicted mathematical result, calculated independently rather than observed in Zoho, is 5.656854249.
4. Check the reasoning: 2 × 4 × 8 × 16 = 1024; four observations mean taking the fourth root, 1024^(1/4) = 5.656854249.
5. In C3, enter =AVERAGE(A2:A5). Its mathematical expectation is 7.5, which differs because AVERAGE uses (2+4+8+16)/4.

For a positive, nonidentical dataset, the harmonic mean is at most the geometric mean, which is at most the arithmetic mean. On these four numbers the independently computed sequence is 4.266666667 ≤ 5.656854249 ≤ 7.5. That inequality is a useful cross-check when comparing three mean types; it does not establish what a particular Zoho build executed.

When the input values have different scales

A mean is only meaningful when each observation represents a comparable quantity. Do not feed raw values such as $100, 20% and 4 hours into GEOMEAN. Convert related rates to consistent factors or use a specialized weighted calculation if each value should contribute differently. GEOMEAN gives every included observation equal weight; it does not accept weights as a separate documented parameter.

Suppose a reseller’s revenue experiences four sequential changes. Enter the actual percentage change in column B, then convert to multiplicative factors in C:

Row: 1

Period
Header

B: Change
Change

C: Growth factor 1 + change
Factor

Row: 2

Period
Q1

B: Change
10%

C: Growth factor 1 + change
1.10

Row: 3

Period
Q2

B: Change
−5%

C: Growth factor 1 + change
0.95

Row: 4

Period
Q3

B: Change
20%

C: Growth factor 1 + change
1.20

Row: 5

Period
Q4

B: Change
−10%

C: Growth factor 1 + change
0.90

1. Type 10%, -5%, 20%, -10% into B2:B5 in that order. Enter =1+B2 in C2 and fill down through C5. Expected factors: 1.10, 0.95, 1.20, 0.90.
2. Enter =PRODUCT(C2:C5) in E2. Independently, 1.10×0.95×1.20×0.90 = **1.1286**. This means an initial amount has multiplied by 1.1286 over all four periods.
3. Enter =GEOMEAN(C2:C5) in E3. The independently calculated expected growth factor per period is 1.030706491964.
4. Enter =GEOMEAN(C2:C5)-1 in E4 and format it as a percentage: expected 3.070649196% per quarter, not 3.75%.
5. Enter =1000*PRODUCT(C2:C5) in E5. A starting amount of 1,000 produces an expected ending amount of 1,128.60 across the four quarters.
6. Optionally enter =AVERAGE(B2:B5) in E6. The arithmetic average percentage change is 3.75%. Applying that percentage as an identical compounded change each quarter would describe a different path.

The result from E4 is the constant quarterly rate that would reproduce the same four-period total multiplication: (1+0.030706491964)^4 = 1.1286 (up to rounding). It is not an annualized rate, a forecast, or an inflation-adjusted return. For equally timed quarterly observations, annualizing the observed four-quarter span means the four-quarter total factor less one, here 12.86%, not multiplying the quarterly rate by four.

Important: Percentage changes must first be converted to factors. =GEOMEAN(B2:B5) is inappropriate here because some B cells hold negative percentages and the mathematical notion of a real positive geometric mean of those signed changes does not apply. An increase of 10% becomes 1.10; a loss of 10% becomes 0.90, not negative 0.10 as an input factor.

For a dashboard with monthly revenue in column B, calculate each month-over-month growth factor in C3 using =B3/B2, then fill down. Use only rows with strictly positive prior-period and current-period revenue for this illustrative workflow, and include the factor for each comparable interval. For example, =GEOMEAN(C3:C14)-1 describes the geometric average change across 12 monthly intervals if all 12 ratios are valid positive numbers.

Be aware of three common analysis errors:

• Twelve revenue values are not twelve transitions. For twelve consecutive monthly revenues, there are only eleven month-to-month ratios. Choose a window based on the number of valid intervals, not the count of revenue labels.
• Zeros are economically significant, but may break a ratio. Revenue of zero in a denominator makes current/prior undefined. Do not silently replace zero with one merely to obtain a result.
• Growth paths need consecutive observations. A missing month makes a simple ratio between the next available months span more than one month. The time interval must be handled before calling it a monthly rate.

A mathematical cross-check for small, strictly positive factors is =PRODUCT(C3:C14)^(1/COUNT(C3:C14))-1. This is an alternative conceptual formula using separately documented functions; it has not been run in Zoho, and if the data contain blanks or unexpected types its effective input set may differ from GEOMEAN. For very long lists, mathematical computation using sums of logarithms can be numerically more stable than multiplying huge products, but Zoho-specific handling of invalid values must still be verified.

The vendor’s possible-error table also includes a generic #N/A! entry; it does not mean GEOMEAN performs a lookup. Separately, text, Boolean values, blanks, error propagation and zero should be checked in Zoho itself before publishing platform-specific coercion rules. Do not import assumptions from the more detailed Excel documentation.

Microsoft Excel documents GEOMEAN(number1, [number2], ...) with comma separators in its English example, allows values or references, and explicitly returns #NUM! when any data point is less than or equal to zero. Its documentation states that text, logical values and blanks inside an array/reference are ignored, but directly supplied logical values and numeric text can have different handling. Those details are Excel-specific, not proof of Zoho’s exact cell coercion.

Google Sheets separately documents GEOMEAN(value1, [value2, ...]) and the nth-root-of-product definition. Its English reference uses comma-separated examples. The mathematical goal is shared, but locale-specific formula syntax and handling of edge cases must still be checked rather than copied blindly between products.

Use AVERAGE for a plain additive mean; use GEOMEAN for equally weighted multiplicative factors; use HARMEAN when the correct question is an average of rates across equal denominators (for example equal-distance travel speeds). The latter use requires extra assumptions explained in the companion guide.

• Zoho Sheet GEOMEAN official reference — official syntax, example and #NUM! remark. Checked October 12, 2026.
• Zoho Sheet HARMEAN official reference — closely related mean with reciprocal weighting. Checked October 12, 2026.
• Zoho Sheet AVERAGE official reference — arithmetic alternative. Checked October 12, 2026.
• Microsoft Excel GEOMEAN reference — Excel-specific syntax and argument/error details. Checked October 12, 2026.
• Google Sheets GEOMEAN reference — Sheets-specific definition and syntax. Checked October 12, 2026.

This proposal is editorial research for Spreadsheet-Tutorials.com, not a published guide. Official Zoho function references were inspected on October 12, 2026. Numeric outcomes are calculated independently in Python using elementary arithmetic; none has been executed in Zoho Sheet. The cited current English web documentation supplies no reliable first-supported version, licensing matrix, or guarantee of identical behavior in every mobile, historical, or beta desktop build. Formula outcomes should be tested in a native Zoho Sheet worksheet before editorial approval.

• HARMEAN — continue with a related Zoho Sheet calculation.
• AVERAGE — continue with a related Zoho Sheet calculation.
• MEDIAN — continue with a related Zoho Sheet calculation.

For a software-specific comparison: LibreOffice Calc GEOMEAN. A shared name does not establish identical argument, error or version behaviour.

The linked official Zoho Sheet function documentation was reviewed on October 12, 2026. Cloud documentation does not establish feature parity across historical clients. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Zoho Sheet execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.