Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

Read: How to use MIN, Max, and AVERAGE Functions of Excel. How to calculate Moving Average in Excel We will calculate the moving average in Excel using two methods.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.