As a regular Excel user, I think you are very much popular with **add** and **divide**. We use those in our day-to-day calculations. Excel gives you a platform where you can use add and divide simultaneously. This article will give an overview of how to add and then divide in Excel. I wish you enjoy the entire article.

**Table of Contents**hide

## How to Use Multiple Order of Operations

When we use multiple orders of operations, it is important to know which operation applies first. It is like multiple mathematical operations.

For example:

**20+400/10=60**

Here, the division will apply first then addition. That’s why we get a result of 60. But if you apply the first bracket in the addition part then it will solve the operation within the first bracket and then do the division.

For Example:

**(20+400)/10=42**

Here, look at the result where you can clearly see just one bracket changes the order of operation and gives a result of 42.

## How to Add and Then Divide in Excel: 5 Suitable Examples

To add and then divide in Excel, we will show you five different examples that are fairly easy to understand. All the five examples will give a clear view of how to add and then divide in Excel.

### 1. Add and Then Divide by Typing within Cell

The first and most easy way to add and then divide in Excel is by typing in a cell. Suppose you have 7 different monthly incomes. You want to find the total income for those seven months and then convert to it euro currency by dividing it by the euro currency conversion coefficient.

**Steps**

- Select cell
**B5**. write the following formula in the formula bar

`=(2500+2300+1700+2600+3000+3500+2300)/1.052632`

- Press
**Enter**to apply this**.**

### 2. Using Cell Reference to Add and Then Divide

Our second method is based on using cell reference. Here, we define the cell instead of typing the values in a cell. We have some monthly incomes in cell **B5** to cell **B11**. we need to find the total income for those seven months and convert it to the Euro currency.

**Steps**

- First, select cell
**D8**. - Write the following formula in the formula bar

`=(B5+B6+B7+B8+B9+B10+B11)/D5`

- Press
**Enter**to apply the formula.

**Read More:** **How to Divide a Number by a Percentage in Excel**

### 3. Add a Range of Cells and Then Divide by a Specific Value

Instead of typing every cell manually, we can apply **the SUM function**. In the **SUM** function, you can select a range of cells and then **divide** it by a specific number. Here, we want to get the total income of all given months in **Dollars** and divide it by the **Euro** currency conversion coefficient to convert it to **Euro**.

**Steps**

- Select cell
**D8**. - Write the following formula in the formula bar. First, it calculates the sum from cell
**B5**to cell**B11**and then divides it by the**Euro**currency conversion coefficient.

`=SUM(B5:B11)/D5`

- Press
**Enter**to apply the formula.

**Read More:** **Division formula in Excel for Multiple Cells**

### 4. Utilizing the QUOTIENT Function

Our next method is based on **the QUOTIENT function**. This function can **divide** two numbers but provides an integer as a result. This function always displays the entire number. For example, if you take a number 10 and divide it by another 3 using the **QUOTIENT** function, it will display 3 as a result. Follow the following steps to use the **QUOTIENT** function.

**Steps**

- Select cell
**D8**. - We want to find the total monthly income by using the
**SUM**function and do the**division**by using the**QUOTIENT**Write down the following formula in the formula bar

`=QUOTIENT(SUM(B5:B11),D5)`

- Press
**Enter**to apply the formula.

**Read More: ****How to Divide One Column by Another in Excel**

### 5. Add and Then Divide Using Paste Special Feature in Excel

Our last example is based on **Paste Special** command. To show this example, we take a dataset where we have the monthly incomes of several persons. They have extra income which we want to add to previous monthly income and divide by weeks of a month to get monthly income.

**Steps**

- Here, we take
**$500**as extra income. - Copy the
**Monthly Income**column value in the**New Monthly Income**.

- Copy the
**Extra Income**column and select the range of cells**E5:E10**.

- Go to the
**Home**tab in the ribbon and select**Paste**from the**Clipboard**group.

- From the
**Paste**option, select**Paste Special**.

- A
**Paste Special**dialog box will appear. Select**Add**in the operation section. Now, click on**OK**

- This will add extra income to all the monthly income.

- Now we need to find out our weekly income. So, copy the
**New Monthly Income**column and paste it into the**Weekly Income**.

- Now, copy the
**Weeks**and select the**Weekly Income**column.

- Next, go to the
**Home**tab in the ribbon and select**Paste**from the**Clipboard**group.

- From the
**Paste**option, select**Paste Special**.

- A
**Paste Special**dialog box will appear. Select**Divide**in the operation section. Now, Click on**OK**.

- Finally, this will automatically divide all the monthly income by four weeks and give
**Weekly Income**.

**Read More: [Fixed] Division Formula Not Working in Excel**

**Download Practice Workbook**

Download this practice workbook

## Conclusion

We have discussed five different and efficient examples to add and then divide in Excel. All the examples are fairly easy to digest. So, If you have any questions, feel free to ask in the comment box, we will respond as quickly as possible.

## Related Articles

**How to Divide for Entire Row in Excel****How to Divide a Column by a Number in Excel****Formula for Addition Subtraction Multiplication and Division in Excel****How to Divide Without Using a Function in Excel****How to Divide with Decimals in Excel****How to Divide a Group of Cells by a Number in Excel****Division Formula with Absolute Reference in Excel****How to Create a Division Formula in Excel****How to Divide in Excel for Entire Column**