To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function. 1. The AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, "The test counts twice as much as the quiz and the final exam counts three times as much as the quiz". 2 ... Note: in the formula, B2:B13 is the range contains the criteria, C2:C13 is the range contains the data you want to calculate average, “Owenton” is the value you will calculate based on. You can change them as you need. Now the sold average of “Owenton” is calculated.

Or, you want to calculate the average temperature on a particular day over a 10-year time span. There are several ways to calculate the average of a group of numbers. The AVERAGE function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution. The three most common measures of central ...