How To Calculate A Weighted Average In Excel Pivot Table Complete Guide

First the AVERAGE function below calculates the normal average of three scores. Kevin a member of The Pivot Ready Course asked a great question about calculating the average of total daily sales in a. In cell D4 of the above you would enter the following formula.

These are the Scores in the data.

Now you will get all averages of each month in the Pivot Table see below screenshots. Figure 1- How to Calculate a Weighted Average in an Excel Pivot Table. Understanding Pivot Table Calculations The Grand Total average in the pivot table is adding up all of the cells in the quantity column of the data set and dividing it by the total number of orders. In order to create a pivot table with a weighted average you will need to do the following.