» Calculating the Average of a Range of Numbers, Excluding the Minimal Value

CATEGORY - Excel Formula and Function VERSION - All Microsoft Excel Versions

Problem:

We want to identify the minimum value from the range A2:B5, and then perform an average calculation of the remaining numbers.

Solution:

Use the SUM, MIN, and COUNT functions in the following formula:
=(SUM(A2:B5)-MIN(A2:B5))/(COUNT(A2:B5)-1)