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

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

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

- 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 like the picture below.

**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)**

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

**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 like 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.

**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

**Calculate Percentage Based on Conditional Formatting (6 Ways)****How to Calculate Percentage of a Number in Excel (5 Easy Ways)****Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Minus Percentage in Excel (2 Methods)****Calculate Percentage Difference Between Two Numbers in Excel****How to Subtract a Percentage in Excel (3 Quick Ways)****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**