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