Function: Ignore Mimimum and Maximum Values
Thanks Duke. That does the trick.
--------------------------------------
"Duke Carey" wrote:
=(SUM(range)-MAX(range)-MIN(range))/(COUNT(range)-2)
"Michael J" wrote:
Is there a spreadsheet function to calculate the average, ignoring a single
minimum and maximum value. This is similar to what they use in the olympics
to calculate a score.
Example: for this list:
A1: 10
A2: 10
A3: 8
A4: 7
A5: 6
A6: 6
A7: 6
I would need to average only cells A2 through A6, ignoring a single max and
min value. The list is normally not sorted and the the number of values is
not constant.
Is there a statistical calulcation to do this?
|