Geomean #NUM! error

[kckay]

I have Excel 2007.

I am using geomean to calculate monthly fecal-e. coli values at a waste water treatment plant. The sample frequency is 1-2 samples weekly. There 8 samples in the month of May. These values range from 0 to 120. May 1 is G135; May 31 is G165. With the exception of the header, the G column is numeric with decimal count 0.

The geomean formula I am using is =GEOMEAN(G135:G165). The format of the geomean field is numeric with 2-pt decimal count.

I get the result #NUM! error.

Thank you for assisting me.

 

[shg]

Regs are regs.

Doing this is so bad mathematically that I expect it's borne of a misunderstanding, misreading, or incomplete reading of the methodology the regulations require.