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

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

Dataset of sum of Percentages in Excel


Method 1 – Using a Generic Formula

We add a new row to calculate the total percentage.

Steps:

  • Select cell D11

Sum of Percentages in Excel Using Generic Formula

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

Sum of Percentages in Excel Using Generic Formula

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

Sum of Percentages in Excel Using Generic Formula


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)

 

SUM Function to Get Sum of Percentages in Excel

  • 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.

Add percentage increase to sum of percentages in excel

Steps:

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

Add percentage increase to sum of percentages in excel

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

Add percentage increase to sum of percentages in excel

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

Add percentage increase to sum of percentages in excel

  • The increased Prices for each item are displayed.

Add percentage increase to sum of percentages in excel


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.

Download Practice Workbook


Related Articles


<<Go Back to Calculating Percentages in Excel | How to Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Souptik Roy
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo