# How to Do Sum of Percentages in Excel (2 Easy Ways)

To demonstrate our methods, we’ll use the following dataset:

### Method 1 – Using a Generic Formula

We add a new row to calculate the total percentage.

Steps:

• Select cell D11

• Enter the following formula:
`=D5+D6+D7+D8+D9+D10`
• Press Enter.

• The sum of the percentages in cells D5-D10 is displayed.

### Method 2 – Apply SUM Function

A more elegant solution is using the SUM function.

Steps:

• Select cell D11.
• Enter the following formula:
=SUM(D5:D10)

• Press Enter.
• The sum of the percentages in cells D5:D10 is displayed.

## Applying Excel Formula to Add Percentage Increase

We’ll use a modified dataset, and calculate new Prices after a percentage increase from the original Price.

Steps:

• Add a new column called New Price.
• Select cell E5.

• Enter the following formula:
`=C5+C5*D5`
• Press Enter.

• The new price is displayed.
• Use the Fill handle to copy the formula from cells E5 to E10.

• The increased Prices for each item are displayed.

## Applying Excel Formula to Add Percentage Markup

The Markup is the difference between the selling price and unit cost, and can be expressed as a percentage as follows:

Percentage Markup= ((Selling Price-Unit Cost)/Unit Cost)*100

To demonstrate in Excel, we’ll again modify our dataset, and calculate the Markup percentage for each Product.

Steps:

• Select cell E5.
• Enter the following formula:
`=((D5-C5)/C5)*100`

• Press Enter.
• The percentage markup is displayed.
• Use the Fill handle to copy the formula from cell E5 down to E10.

• The percentage markup of the whole dataset is displayed.

## Things to Remember

• Autosum functions will not work to obtain the sum of percentages. Use one of the Methods above instead.

## Related Articles

<<Go Back to

Get FREE Advanced Excel Exercises with Solutions!
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF