G
Guest
Hi,
I am using this formula to calculate a geomean, but would like to omit line
13 and 17 and 19 in the o9
24 range.
{=EXP(AVERAGE(LN(1+O9:O24)))-1}
I am using this formula to calculate a geomean, but would like to omit line
13 and 17 and 19 in the o9
![Blush :blush: :blush:](/styles/default/custom/smilies/blush.gif)
{=EXP(AVERAGE(LN(1+O9:O24)))-1}