Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average formula
I need a formula that will figure the average of any range of numbers
dropping the lowest number Thomas Goldstein |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Or an array formula to exclude all instances of the minimum value
=AVERAGE(IF(H1:H14<MIN(H1:H14),H1:H14)) to be entered with ctrl+shift+enter -- Don Guillett SalesAid Software "JE McGimpsey" wrote in message ... 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |