Average an Excel range - ignoring blank, text or error cells & largest & smallest
Click here to access the workbook used in this example.
https://spreadsheetvault.com/average-...
0:04 Introduction
0:35 1st AVERAGEIFS approach
3:07 1st AVERAGEIFS formula
3:30 2nd AVERAGEIFS approach
5:39 2nd AVERAGEIFS formula
5:50 Further examples of AVERAGEIFS
This tutorial will present one way to return an average of an Excel range, whilst ignoring blanks, text, errors, as well as excluding the largest and smallest value in a range.
In this example, the AVERAGEIFS formula must disregard the largest value, 40, and the smallest value 10. The 90 value is already ignored because its Transaction # in cell B15 is blank.
We will present 2 options to use with the AVERAGEIFS formula.