Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of a list with high and low ignored
In the example below, there are 8 of a possible 10 numbers. The amount
varies but never more than 10. These numbers represent a value of an equation earlier on in the worksheet. I need to be able to formulate the average of these numbers after the high and low has been removed. In this case, 52.28 would not be used nor would 50.81. I currently use {=AVERAGE(IF(D4:D150,D4:D15))} to do the average of all but need to remove the high and low automatically. Can anyone assist in this? Thanks in advance. 51.32 51.54 51.74 50.93 52.28 51.07 51.85 50.81 Blank Blank = Average with the high and low taken out |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of a list with high and low ignored
=(SUM(D4:D13)-MIN(D4:D13)-MAX(D4:D13))/(COUNT(D4:D13)-2)
"Shu of AZ" wrote: In the example below, there are 8 of a possible 10 numbers. The amount varies but never more than 10. These numbers represent a value of an equation earlier on in the worksheet. I need to be able to formulate the average of these numbers after the high and low has been removed. In this case, 52.28 would not be used nor would 50.81. I currently use {=AVERAGE(IF(D4:D150,D4:D15))} to do the average of all but need to remove the high and low automatically. Can anyone assist in this? Thanks in advance. 51.32 51.54 51.74 50.93 52.28 51.07 51.85 50.81 Blank Blank = Average with the high and low taken out |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of a list with high and low ignored
if the blank cells are truly blank then... =(SUM(D4:D15)-MIN(D4:D15)-MAX(D4:D15))/(COUNTA(D4:D15)-2) Note that D4:D15 has twelve cells not ten. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Shu of AZ" wrote in message In the example below, there are 8 of a possible 10 numbers. The amount varies but never more than 10. These numbers represent a value of an equation earlier on in the worksheet. I need to be able to formulate the average of these numbers after the high and low has been removed. In this case, 52.28 would not be used nor would 50.81. I currently use {=AVERAGE(IF(D4:D150,D4:D15))} to do the average of all but need to remove the high and low automatically. Can anyone assist in this? Thanks in advance. 51.32 51.54 51.74 50.93 52.28 51.07 51.85 50.81 Blank Blank = Average with the high and low taken out |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of a list with high and low ignored
Why have you started a new thread here, when you have answers in your
other thread that you say are acceptable? Pete On Feb 6, 4:49*pm, Shu of AZ wrote: In the example below, there are 8 of a possible 10 numbers. *The amount varies but never more than 10. *These numbers represent a value of an equation earlier on in the worksheet. *I need to be able to formulate the average of these numbers after the high and low has been removed. *In this case, 52.28 would not be used nor would 50.81. *I currently use {=AVERAGE(IF(D4:D150,D4:D15))} to do the average of all but need to remove the high and low automatically. *Can anyone assist in this? *Thanks in advance. 51.32 51.54 51.74 50.93 52.28 51.07 51.85 50.81 Blank Blank = Average with the high and low taken out |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average a List and sorting | Excel Worksheet Functions | |||
Average the last 7 numbers on a list | Excel Worksheet Functions | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
High score list? | New Users to Excel |