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.
Watch video Average an Excel range - ignoring blank, text or error cells & largest & smallest online without registration, duration hours minute second in high quality. This video was added by user Strategize Financial Modelling 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,262 once and liked it 7 people.