Thread: Geomean range
View Single Post
  #1   Report Post  
Stephen
 
Posts: n/a
Default 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