#FIELD! error

Hi Armas, Monica

Based on my research, a negative value could indeed be part of the issue with the GEOMEAN calculation. The geometric mean is intended for positive values, so if the referenced range contains a value that is 0 or negative, GEOMEAN cannot calculate the result normally. In that situation, however, Excel would typically return a #NUM! error rather than#FIELD!.

For more information, you can refer to: GEOMEAN function | Microsoft Support

Since you are seeing #FIELD!, I would recommend checking the referenced cells as well. Please make sure they contain regular numeric values and are not using a linked data type or an invalid field reference. Microsoft documents #FIELD! as an error associated with invalid or unavailable fields in linked data types.

As a quick test, you could try GEOMEAN with a small range containing only ordinary positive numbers, for example:

=GEOMEAN(A1:A5)

Enter values such as 2, 4, 6, 8, and 10 in A1:A5. If this works, then check the original range for negative/zero values and whether any of the cells are using special data types rather than regular numeric values.

If the issue continues, could you share the exact GEOMEAN formula you are using and, if possible, a screenshot showing the formula and a few of the referenced values? Please remove any sensitive information first.

I hope this information helps and look forward to your response.