Looking for ways to **calculate the total percentage** from **multiple percentages **in Excel? Then, this is the right place for you. Here, you will find 3 effective ways to **calculate the total percentage **in Excel.

## Download Practice Workbook

You can download the workbook to practice yourself.

## What Is Percentage?

**The percentage **is a **comparative figure **representing **100ths **of any **amount**.

The basic **formula of Percentage** is:

`Percentage = (Part/Total) * 100`

## How to Calculate Percentages in Excel

You can **calculate the percentage **in Excel by following some easy steps. Suppose you have a dataset containing the name of some **Products**, and the number of **Ordered **and **Received **items. Now, we will show you how you can **calculate **the **Percentage of Received Orders** using this dataset.

**Steps:**

- Firstly, select cell range
**E5:E11**. - Then, go to the
**Home tab**>> click on**Number**>> click on**Number Format**.

- Next, click on
**Percentage**.

- Now, select
**Cell E5**and insert the following formula.

`=D5/C5`

- Then, press
**Enter**. - After that, drag down the
**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

**divided**the value of

**Received**items in

**Cell D5**by the values of

**Ordered items**in

**Cell C5**.

- Finally, you will get all the values of the
**Percentage of Received Orders**.

## 3 Effective Ways to Calculate Total Percentage from Multiple Percentages in Excel

Here, we have a dataset containing the name of some **Products **and their corresponding **Percentage Amount**. We can **calculate **the **total percentage** of this dataset going through some effective steps.

Now, we will show you how to **manually calculate the total percentage** from **multiple percentages** and use **Excel functions**.

### 1. Use Excel SUM Function to Get Total Percentage from Multiple Percentages

In the first method, we will use **the SUM function** to get the** total percentage** from **multiple percentages** in Excel. Follow the steps given below to do it on your own dataset.

**Steps:**

- In the beginning, select
**Cell C11**and insert the following formula.

`=SUM(C5:C10)`

- After that, press
**Enter**to get the**Total Percentage**value.

**SUM**function, we inserted cell range

**C5:C10**to add all the values in this range.

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

**Similar Readings**

**Calculate Percentage of Percentage in Excel (2 Examples)****How to Calculate Annual Growth Rate in Excel (3 Methods)****Calculate Percentage of Completion in Excel (3 Methods)****How to Calculate Gross Profit Margin Percentage with Formula in Excel****Food Cost Percentage Formula in Excel (3 Suitable Examples)**

### 2. Calculate Total Percentage from Multiple Percentages Manually

You can also **calculate **the **total percentage **from **multiple percentages manually **by going through the steps given below.

**Steps:**

- To start with, select
**Cell C11**and insert the following formula.

`=C5+C6+C7+C8+C9+C10`

- Then, press
**Enter**.

**added**the values of the cell range

**C5:C10**by

**manually**adding them

**one by one**.

**Read More: ****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**

### 3. Avoid Errors with Excel IFERROR Function to Determine Total Percentage

Finally, sometimes you may find some **errors **while adding the **percentages** using **formulas**. You can avoid these errors by using **the IFERROR function**.

Here, in the dataset, if we want to **calculate **the **Percentage of Received Orders** using the **formula **shown **above**, we will find a **#DIV/0! Error** in **Cell E11** as there is no value in **Cell C11**.

Now, follow the steps given below to avoid this **error **using the **IFERROR **function in Excel.

**Steps:**

- Firstly, select
**Cell E5**and insert the following formula.

`=IFERROR(D5/C5,0)`

- After that, press
**Enter**and drag down the**Fill Handle**tool to**AutoFill**the formula for the rest of the cells.

**IFERROR**function, we inserted the

**resultant**value of

**Cell D5**

**divided**by

**Cell C5**as

**value**and

**0**as

**value_if_error**.

- Now, you will get all the values of the
**Percentage of Received Orders**.

- Then, select
**Cell C13**and insert the following formula.

`=SUM(E5:E11)`

- Finally, press
**Enter**to get the value of the**Total Received Order**.

**SUM**function, we inserted the values of cell range

**E5:E11**to add all these values.

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

## Practice Section

In the article, you will find an Excel workbook like the image given below to practice on your own.

## Conclusion

So, in this article, we have shown you 3 ways to **calculate the total percentage** from **multiple percentages **in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Additionally, please let us know if there are any more alternatives that we may have missed. And, visit **ExcelDemy** for many more articles like this. Thank you!

## Related Articles

**How to Use IF and Percentage Formula in Excel (2 Easy Ways)****Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)****How to Calculate Percentage in Excel Based on Cell Color (4 Methods)****Calculate Percentage of a Number in Excel (5 Easy Ways)****How to Calculate Average Percentage in Excel (3 Easy Methods)****Percentage Difference Between Two Percentages in Excel****How to Calculate Contribution Percentage with Formula in Excel**