On 2002-03-12 14:06, Tim Francis-Wright wrote:

Ahhh, I know what's happening... the product of the values is exceeding Excel's max value, 9.99999999999999E+307. See the Excel Help topic for "What does the error #NUM! mean?"

GEOMEAN apparently takes the product of a range of numbers, then takes the nth-root

of that product (where n is the number of arguments).

You can work around this by figuring the nth-roots first, then taking the product.

There's surely a clever UDF in someone's brain, just waiting to break out. But here's

a straightforward way to do this.

If B2:B377 have your numbers, have

C1 = 1/COUNT(B2:B377)

C2 = B2^$C$1 (and so on down to C377)

Then D1 = PRODUCT(C2:C377) is your geometric mean.

## Like this thread? Share it with others