It seems to me that if you change 0s to 0.00000000001 the data for your
GEOMEAN function will be "meaningfully altered".
If you've got 99 1s, the GEOMEAN would of course be 1, but if you add one
sample of 0.00000000001 to the series the GEOMEAN becomes 0.776247.
--
David Biddulph

"NC2A''''DAM" wrote in message
...
Mike - I understand it is fundamentally flawed. I am simply planning on
replacing the 0s with 0.00000000001, so that the data will not be
meaningfully altered. I will be able to work around the negatives for the
time being. All of my steps will be disclosed. And I do appreciate you
looking after the integrity of academics. However, I will see if I can get
your recommended formula to give me error-free results.

Dana - Thank you. I will see if there is too much data to take a GEOMEAN,
but I believe we should be okay. At most a hundred cells are necessary for
me
to find each required GEOMEAN. There will just be a bunch of these
geometric
means.

"Dana DeLouis" wrote:

NC2A''''DAM wrote:
Hey Mike:

I posted the file to savefile.com just so you can check it out. You are
right though, I must take out all the negative numbers and zeros before
it is
willing to calculate the geometric mean. I will get right on it.

Thank you very much for your help!!


<snip

As a side note, it doesn't take many numbers for GeoMean to return an
error because of overflow.
Perhaps use the alternate equation for GeoMean...
It's an array formula. Samll test area A1:A4

=Exp(Average(If(A1:A40,A1:A4)))

- - -
HTH
Dana DeLouis