"Dan Knight" wrote in message
...
We have workbook that uses the GEOMEAN function on a column of data. The
values being analyzed are returned by the formula =IF(M1=0," ",M1) to
ensure
that there are no zero values. On one sheet =GEOMEAN(N2:n784) works find;
On
another sheet =GEOMEAN(N2:n1450) returns the #NUM error. The only
difference
between the two sheets is the number of rows. On the sheet that returns
the
error, if we change the formula to =GEOMEAN(N2:N394) it works, but as soon
as
we include cell N395 or higher, it returns the error.

Any Suggestions?

--
Dan Knight



My guess is that there is an internal overflow somewhere.

The only difference between the two sheets is the number of rows
Are the numbers in the range the same?

/Fredrik