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.