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.
How to Do Sum of Percentages in Excel: 2 Easy Ways
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 results.
1. Find the Sum of Percentages in Excel Using a 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
- Then, copy the following formula in the selected cell.
=D5+D6+D7+D8+D9+D10
- After that, press the Enter
- Consequently, you will find the result in the picture below.
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.
- Then press Enter.
- As a result, you will find the sum of percentages in the D11Â cell.
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.
Steps:
- First, add a new column called New Price.
- Then, select the E5Â cell.
- After that copy the following formula in the selected cell.
=C5+C5*D5
- Then, press Enter.
- As a result, you will find the value in the picture shown below.
- Then, Fill handle the formula from E5 to E10.
- At last, you will get the result like the picture shown below.
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 values to get the sum of percentages. You have to follow any of the methods described earlier.
Download Practice Workbook
Please download the workbook to practice yourself.
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. I hope you have enjoyed the whole tutorial. If you have any questions, feel free to ask me in the comment section. Don’t forget to give us your feedback.
Related Articles
- How to Add Percentage to Price with Excel Formula
- How to Add 20 Percent to a Price in Excel
- How to Subtract a Percentage in Excel
- How to Subtract 10 Percent in Excel
- How to Use Excel Formula to Calculate Percentage of Grand Total
- How to Add 10 Percent to a Number in Excel
- How to Add 15 Percent to a Price in Excel
- How to Subtract a Percentage from a Price in Excel