Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
thomas wald
 
Posts: n/a
Default Average formula

I need a formula that will figure the average of any range of numbers
dropping the lowest number

Thomas Goldstein


  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

=(SUM(rng)-MIN(rng))/(COUNT(rng)-1)

This assumes that you mean to drop only one value if there are multiple
instances of the "lowest number".

In article ,
"thomas wald" wrote:

I need a formula that will figure the average of any range of numbers
dropping the lowest number

Thomas Goldstein

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula works in some cells, doesn't in other Wowbagger New Users to Excel 13 June 30th 05 03:21 PM
AVERAGE and STDEV functions with logic t-rung Excel Worksheet Functions 1 May 26th 05 07:11 PM
Howdo U copy a formula down a column, that uses data in another w. Need Help pasting a formula Excel Worksheet Functions 1 February 25th 05 07:04 PM
Howdo U copy a formula down a column, that uses data in another w. brantty Excel Worksheet Functions 0 February 25th 05 11:11 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 02:27 AM


All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"