average

I stumbled upon an interesting question the other day, which was; ‘how do I find the average of a range of numbers that meet criteria, and by the way, I want to exclude the outliers?’ Now, if all we needed was a simple average that met criteria we could use an AVERAGEIF or AVERAGEIFS formula. …