# Documentation/Calc Functions/GEOMEAN

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

GEOMEAN

## Category:

Statistical Analysis

## Summary:

Calculates the geometric mean of a set of numbers. The geometric mean of a set of N numbers is the Nth root of the product of the numbers.

## Syntax:

GEOMEAN(**Number 1** [; **Number 2** [; … [; **Number 255**]]])

## Returns:

Returns a non-negative real number which is the geometric mean of the set of numbers.

## Arguments:

**Number 1**, **Number 2**, ..., **Number 255** are numbers, references to cells or to cell ranges of numbers for which the geometric mean is to be calculated.

- If any of the arguments contain a value less than zero then the function returns an error value. However, empty cells and those with non-numeric (except for logical) values are ignored.

## Additional details:

- The formula for GEOMEAN is:

where N is the set of numbers passed as arguments and n is the size of that set. To find the value of n, use the function COUNT(N).

- For more details on the geometric mean, visit Wikipedia.

## Examples:

Formula | Description | Returns |
---|---|---|

=GEOMEAN(23.5;46.7;69.5;4.54) | The function calculates the geometric mean of the arguments passed. | 24.2580758724851 |

=GEOMEAN(A1:A5) where A1:A5 contains 1,2,3,4,5 respectively | The function calculates the geometric mean of the arguments passed. | 2.60517108469735 |

=GEOMEAN(A1:A5) where A1:A5 contains 1,2,-3,4,5 respectively | The function returns an error value since one of the arguments passed contains a negative value. | Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

GEOMEAN