Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
Stephen wrote...
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} =EXP(AVERAGE(LN(1+O9:012),LN(1+O14:O16),LN(1+O18), LN(1+O20:O24)))-1 or =EXP(SUM(LN(1+O9:O24)*{1;1;1;1;0;1;1;1;0;1;0;1;1;1 ;1;1})/13)-1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
ClearContents method on a passed range | New Users to Excel | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range name | Excel Worksheet Functions |