# GEOMEAN

## Content

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

## Syntax

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

## Arguments

<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">This function has these arguments:</span>

| <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Argument</span> | <span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">Description</span> |
| -------- | ----------- |
| *<span data-teams="true" style="margin: 0px; padding: 0px; -webkit-font-smoothing: antialiased; box-sizing: border-box;">number1, number2, ...</span>* | Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the mean. You can also use a single array or a reference to an array instead of arguments separated by commas. |

## Remarks

You can use this function to calculate average growth rate given compound interest with variable rates.
The equation for this function is:
![](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-GEOMEAN.png)

## Examples

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