How to use a formula in Excel to calculate the average of a data sample without the highest and lowest values

View products that this article applies to.

This article was previously published under Q213495

Expand all | Collapse all

SUMMARY

For statistical purposes, you may want to calculate the average of a data sample without the sample's highest and lowest values. To do this in Microsoft Excel, you can use the following formula:

   =(SUM(region)-MAX(region)-MIN(region))/(COUNT(region)-2)

Note To use this formula in Excel, you must include the parentheses the way that they appear in this formula. Do this to make sure that the function is computed in the correct order.