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.

**Table of Contents**hide

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

**=SUM(D5:D10)**

- 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