how to calculate geomean in numbers

Hi Camaro,

There is a function called GEOMEAN.

Type = in a cell to bring up the Function Browser. Type geo

Regards,

Ian.

type the "=" in a cell then type "geomean("

Here is a sneppet of help from Numbers:

The GEOMEAN function returns the geometric mean of the specified number values.

GEOMEAN(pos-num, pos-num…)

• pos-num: A number greater than 0.
• pos-num…: Optionally include one or more additional positive numbers.

Notes

GEOMEAN multiplies the arguments to arrive at a product and then takes the root of the product that is equal to the number of arguments.