How to calculate average percentage in excel pivot table

Often you may want to calculate an average percentage of some dataset. Fortunately this is easy to do using built-in functions in Excel.

This tutorial provides two examples of how to calculate an average percentage in different scenarios.

Example 1: Calculate Average Percentage with Percentages Only

Suppose we have the following list of percentages in Excel:

To calculate the average percentage, we can type the following formula into cell B11:

Once we press Enter, the average percentage will be shown:

We can see that the average percentage is 81.94%.

Example 2: Calculate Average Percentage with Counts & Percentages

Suppose we administer a survey to parents, students, and teachers at a certain school and ask them if they would be in favor of a new school rule.

The following dataset shows the number of people who responded to the survey in each of the three groups along with the percentage of individuals in each group who are in favor of the new rule:

We can use the following formula to calculate the average percentage of individuals wh

how to calculate average percentage in excel pivot table

how to calculate average percentage in excel using formula