Harlan Grove has posted this array formula in the past:

=EXP(AVERAGE(LN(A2:A200)))

entered with CTRL+SHIFT+ENTER.

On Fri, 18 Feb 2005 00:20:20 +0100, "Fredrik Wahlgren"
wrote:


"Dan Knight" wrote in message
...
Fredrik;
I appreciate your willingness to answer my problem, however, I'm afraid I
have no idea what your response actually means:
1) What is "an internal overflow"
2) How do I tell if that is the case?
3) Practical suggestions on how to overcome or work around said "internal
overflow".

Thanks,



GEOMEAN returns the nth root of the product. I think the product of these
values is simply too big. Excel can't handle numbers bigger than some value
which I think you have exceeded. Or you may have a zero somewhere.

You can find an add-in that implements geomean with ahigher capacity he
http://longre.free.fr/english/

Why do you want to calculate geomean with so many values?

/Fredrik