# GEOMEAN

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the geometric mean of a set of positive data.

## Syntax

GEOMEAN(*value1*,*value2*,...)
GEOMEAN(*array*)
GEOMEAN(*array1*,*array2*,...)

## Arguments

You can specify a set of numeric values. You can also use a single array or a reference to an array instead of arguments separated by commas. If an array or reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero. This function can have up to 255 arguments.
Data should be provided so that the value arguments should be greater than zero.

## Remarks

You can use this function to calculate average growth rate given compound interest with variable rates.
The equation for this function is:
![GEOMEAN Equation](https://cdn.mescius.io/document-site-files/images/0ed25d3e-6b2a-4cf0-8f1b-7ed5ab18cf12/artwork/func-geomean.png)

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`GEOMEAN(F1:F9)`
`GEOMEAN(R1C6:R9C6)`
`GEOMEAN(35,31,47,51,37,31,58,39)` gives the result 40.1461796637

## Version Available

This function is available in product version 1.0 or later.

## See Also

[HARMEAN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionHARMEAN) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)