How do you find the average of percentages in Excel?

To find the average of percentages in Excel, follow these steps:

• Create two columns of data: One with the percentages and one with the count of each sample set. (For example, if you interviewed 200 people and 80% of them said they like ice cream, one column would have 200 and one would have 80%.)

• In an empty cell, type =SUMPRODUCT.

• Follow =SUMPRODUCT with a starting parenthesis "(".

• Enter the range of cells where your sample set count values are, followed by a comma. Here's an exmaple: C2:C13.

• Enter the range of cells where your percentage values are and close the parenthesis so it looks like (C2:C13, D2:D13).

• Type the divide symbol:/.

• Type SUM followed by your sample set value range -- the complete formula will look something like this:

  =SUMPRODUCT(C2:C13, D2:D13)/SUM(C2:C13).

• Hit "Enter" to see your result.