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

While working with a dataset, sometimes, you need to make a percentage. After getting percentages, the sum of percentages may be required. In Excel, there are a few ways to do the sum of percentages. In this article, I will show the procedures to get the sum of percentages in Excel. I will show two handy ways to sum the percentages. I will describe the procedure with the necessary steps and illustrations.


Download Practice Workbook

Please download the workbook to practice yourself.


2 Easy Ways to Do Sum of Percentages in Excel

Here is the dataset on the Product Report of XYZ Traders. You can see three columns B, C, and D called Product Name, Amount, and Percentage. The dataset ranges from B4 to D10. From here, I will jump into the solution to our problem. Keep following the steps and get your result.

Dataset of sum of Percentages in Excel


1. Find Sum of Percentages in Excel Using Generic Formula

This is the first method of this article. I will use a simple generic formula here. I have a new row to get the total percentage. Follow the steps given below. You can also check the illustrations to get the sum.

Steps:

  • Select the D11

Sum of Percentages in Excel Using Generic Formula

  • Then, copy the following formula in the selected cell.
=D5+D6+D7+D8+D9+D10
  • After that, press the Enter

Sum of Percentages in Excel Using Generic Formula

  • Consequently, you will find the result like the picture below.

Sum of Percentages in Excel Using Generic Formula

Read More: How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)


2. Apply SUM Function to Get Sum of Percentages in Excel

In this portion of the article, I will show the last but not least method to do the sum of percentages in Excel. You will see the application of the SUM function here. I consider the same dataset used in the previous method. Follow the procedures step by step. If you face any problem, the illustrations will help you understand the procedure properly.

Steps:

  • First, select the D11 cell.
  • Then, write down the following formula in the selected cell.
=SUM(D5:D10)

SUM Function to Get Sum of Percentages in Excel

  • Then press Enter.
  • As a result, you will find the sum of percentages in the D11 cell.

Read More: How to Use Excel Formula to Calculate Percentage of Grand Total


Use of Excel Formula to Add Percentage Increase

This is the added portion of this article. In this part of the article, I will show the use of an excel formula to Add Percentage Increase. An increasing percentage of a product is a very common phenomenon in the business field. Therefore, adding a percentage increase using an Excel formula is very important to know. I have set a new data table for this part of the article. You can see three columns containing the Product Name, Price, and Increase. Follow the steps given below.

Add percentage increase to sum of percentages in excel

Steps:

  • First, add a new column called New Price.
  • Then, select the E5 cell.

Add percentage increase to sum of percentages in excel

  • After that copy the following formula in the selected cell.
=C5+C5*D5
  • Then, press Enter.

Add percentage increase to sum of percentages in excel

  • As a result, you will find the value like the picture shown below.
  • Then, Fill handle the formula from E5 to E10.

Add percentage increase to sum of percentages in excel

  • At last, you will get the result like the picture shown below.

Add percentage increase to sum of percentages in excel

Read More: How to Calculate Growth Percentage Formula in Excel


Applying Excel Formula to Add Percentage Markup

In the business area, sometimes you need to Add a Percentage Markup. Now the question comes to mind what is percentage markup? Actually, markup means the difference between the selling price and unit cost. Moreover, percentage markup means that

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

Here, I will consider a new dataset having four columns B, C, D, & E called Product Name, Unit Cost, Selling Price, and Markup Percentage. Hence, I will show the steps to add percentage markup by applying an Excel formula. Follow the steps given below.

Steps:

  • Select the E5 cell first.
  • Then write down the following formula in the E5 cell.
=((D5-C5)/C5)*100

  • After that, press Enter.
  • As a result, you will get the percentage markup.
  • Then, Fill handle the formula from E5 to E10.

  • As a result, you will find the percentage markup of the whole dataset.


Things to Remember

  • You will not get any autosum value to get the sum of percentages. You have to follow any of the methods described earlier.

Conclusion

In this article, I have tried to explain the procedure for the Sum of Percentages in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. You will find such interesting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo