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.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

If you leave z out, Excel will average the values identified in argument x. AVERAGEIF in Action Let's jump straight in and see how the AVERAGEIF function works in a real-world example.