# How to Calculate Percentage of Percentage in Excel (2 Examples)

### Example 1 – Calculate the Percentage of Percentage from Raw Data

We have population data from a census where the percentages of Males and Children are provided separately. We’ll determine the number of male children in the population.

Steps:

• Add a new column in column F for the results.
• Enter the following formula in cell E5:
`=C5*D5*E5`

C5*D5= Population x Male Percentage = Male Population

(C5*D5)*E5= Male Population x Child Percentage = The number of boys in the population

• Drag down the fill handle to complete the series.

• We got the number of male children by using the percentage of a percentage.

### Example 2 – Calculate the Percentage Increase or Decrease from Percentage Data

Steps:

• We have a store’s monthly profit data where the percentage of increase or decrease is provided.
• Calculate the amount of shared profit with the following formula in cell E5:
`=C5*E5`
• Drag the fill handle down to get all the shared profits.

• Determine the profit increase or decrease by entering the following formula in cell F5:
`=(E6-E5)/E5`

(E6-E5) = Profit increase or decrease

(E6-E5)/E5= Ratio of profit increase or decrease and initial profit

• Drag down the fill handle.

## How to Calculate the Average Percentage of Percentage in Excel

We have Voter numbers and Percentage of Votes in Favor from an election.

• Compute the average proportion of votes cast in favor using the following formula:
`=SUMPRODUCT(C5:C14,D5:D14)/SUM(C5:C14)`

Formula Breakdown:

• SUMPRODUCT(C5:C14,D5:D14)

SUMPRODUCT will multiply Voter Nos. in cell C5 with % Votes in Favor in D5 and continue the process up until 14th row after that the function will add up the products.

Output: 61628

• SUM(C5:C14)

This adds values from C5 to C14.

Output: 110100

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF