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

### Method 1 – Using a Generic Formula

We add a new row to calculate the total percentage.

**Steps:**

- Select
**cell****D11**

- Enter the following formula:

`=D5+D6+D7+D8+D9+D10`

- Press
**Enter**.

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

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

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

**Steps:**

**Add**a new column called**New Price**.- Select
**cell****E5**.

- Enter the following formula:

`=C5+C5*D5`

- Press
**Enter**.

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

- The increased Prices for each item are displayed.

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

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

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