Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.
The article How to do more advanced averaging in Excel reviews Microsoft Excel’s many averaging functions. The focus is how the functions evaluate zero and Boolean values and empty string values. These functions won’t always be adequate, though. In fact, sometimes you’ll need an expression that doesn’t use any averaging functions at all. In this article, we’ll look at some unique averaging solutions.
SEE: 69 Excel tips every user should master (TechRepublic)
I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier…