Hi,

You could also use either of these:

=-GEOMEAN(-F2:F10)
=-GEOMEAN(ABS(F2:F10))

The second is more intuitive, but longer and both are arrays.

Cheers,
Shane

"Dave F" wrote:

On Nov 11, 8:46 pm, Dave F wrote:
The GEOMEAN function calculates the geometric mean for a series of
positive numbers.

I have a series of negative numbers (asset returns) for which I want
to calculate the geometric mean.

Is there any easy way to calculate this? The series is about 30
numbers long and I would prefer not to build this manually...

Thanks in advance.

Actually, the following as an array formula seems to work: =GEOMEAN
(F2:F29*-1)*-1

Strange workaround but it makes sense logically.