» Calculating the Average of a Range of Numbers, Excluding the Minimal Value
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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)
Book Store:
Recommended Books:
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
