Did you enter it as an array?

Type the formula then with the cursor still in the formula bar hit

Ctrl+Shift+Enter

Mike

"Nick Curties" wrote:

Thanks for the reply. When I use the formula you provided, I get a #VALUE!
result. All the values I'm using are positive and I have tried copying the
values to a different area to ensure there is nothing strange in any of the
cells and rounding to the nearest integer. For information, the Geometric
mean is just below 60 when the error occurs.

"Mike H" wrote:

Yoe get a NUM error if the dataset includes negative values, zeroes or (and
most likely) with a very large dataset you are hitting a number larger than
Excel can handle so it bombs with a NUM error.

use instead

=EXP(AVERAGE(LN(A1:A300)))

Entered as an array ctrl+shift+enter. It will wobble for neg's and zeroes
but overcomes the Excel max va,ue problem.

Mike

"Nick Curties" wrote:

I have a set of around 400 values in a sheet which range between 1 and
200,000. When I try to calculate the GEOMEAN value I get a #NUM! result. If I
calculate the accumulating GEOMEAN (A1:A1, A1:A2, A1:A3 etc.) I find that the
#NUM! starts when I hit the 174th item, which looks normal at about 139. If I
calculate the GEOMEAN in chunks of 50 values (A1:A50, A2:A51, A3:A52 ...
A150:A199 etc.) the calculation goes past this 174th item with no problems.
If I manually edit the value, I can set it to any number from 0 to 51 and
the calculation will take place correctly; however, the #NUM! returns at the
calculation of the 175th item.