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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Passing a range name as an argument to the Index Function	Michael Sharpe	Excel Discussion (Misc queries)	3	September 5th 12 01:33 PM
ClearContents method on a passed range	bryan	New Users to Excel	2	January 19th 05 08:49 AM
named range refers to: in a chart	Spencer Hutton	Excel Discussion (Misc queries)	1	December 14th 04 10:15 PM
range names	Pedro	Excel Worksheet Functions	1	November 9th 04 06:27 PM
range name	Pedro	Excel Worksheet Functions	0	November 9th 04 06:22 PM

All times are GMT +1. The time now is 01:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us