Thread
:
Geomean range
View Single Post
#
1
Stephen
Posts: n/a
Geomean range
Hi,
I am using this formula to calculate a geomean, but would like to omit line
13 and 17 and 19 in the o9:o24 range.
{=EXP(AVERAGE(LN(1+O9:O24)))-1}
--
Stephen
Reply With Quote