Average a range without highest and lowest values
For statistical purposes, you may want to calculate the average of a data sample without its highest and lowest values.
The formula to do this is
=(SUM(range)-MAX(range)-MIN(range))/(COUNT(range)-2)
The use of this formula is illustrated below.
