"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