How to Subtract Multiple Cells in Excel

Learn expert tips for using mathematical functions in Excel.

Microsoft Excel is the best spreadsheet software in which you can do every calculation by adding formulas, tools, graphing tools, tables, etc. Calculation in Excel becomes easy; you can do any long calculation and manage the data in an organized way. Many times, people raise the question of how to subtract 20 cells in Excel so that they can solve the data. So, if guys are aware of the shortcut method or formula, you can easily do it. Otherwise, it will consume time. In this article, you will get to know how to subtract multiple cells in Excel. Continue reading till the end to learn more.

How to Subtract Multiple Cells in Excel

How to Subtract Multiple Cells in Excel

There are three methods to know how to subtract multiple cells in Excel. The subtraction formula is also the same in Google Sheets as it is in Excel spreadsheets. If anyone has come across the problem of subtraction of multiple cells, then they can solve the problem from any of these methods.

Let’s look at these methods in detail.

Method 1: Use Formula

For doing subtraction, you need to have the data and here you will see the subtraction.

1. Open the Microsoft Excel application on your PC/laptop and open the desired sheet.

2. Insert = symbol where you want the subtraction.

Insert equal to sign where you want the subtraction.

3. Click on the first cell.

Click on the first cell. | How to Subtract Multiple Cells in Excel

4. Insert subtraction (-) symbol.

Insert minus sign.

5. Select the second cell.

Select the second cell.

6. Again, insert a subtraction (-) symbol and select the next cell up to where you want the subtraction.

7. Press the Enter key on your keyboard.

Again insert a minus sign and select the next cell up to where you want the subtraction and Press Enter. | How to Subtract Multiple Cells in Excel

8. Drag down the answer cell from the corner to get the calculation for other rows with the same formula.

Drag down if you want the other calculation in the same formula and you can do it by selecting the cell where the formula was written and at the corner plus sign will appear, drag it down to the end.

Here the first method has been done, and the formula can be used both horizontally and vertically.

Also Read: How to Make Excel File Read Only

Method 2: Use SUM Function

Those who want to subtract the data from the SUM function can use this formula. By this formula, you can subtract multiple cells from one cell in MS Excel and Google Sheets. The SUM function can also be used in both ways horizontally and vertically. For example, if you want to subtract expenditure from your income, you can use this formula and it works for you.

1. Insert = symbol in the cell where you want the subtraction.

Insert equal to sign in the cell where you want the subtraction.

2. Click on the first cell you want to subtract other multiple cells with.

Click on the first cell you want to subtract other multiple cells with. | How to Subtract Multiple Cells in Excel

3. Insert subtraction (-) symbol.

Insert minus sign.

4. Then, type the function SUM, as shown below.

Type the word SUM.

5. Select another cell to include in the subtraction.

Insert the next values in the bracket and Select another cell you want the subtraction. | How to Subtract Multiple Cells in Excel

6. Put a colon (:) after selecting a cell.

7. Select the last cell you want the subtraction of.

Put a colon after selecting a cell and Select the last cell you want the subtraction off.

8. Press the Enter key.

9. Drag down the answer cell to get the answers for the other cells with the same formula.

Press Enter and Drag down if you want the same formula to be used.

Method 3: Use Paste Special Feature

For people who want to do subtraction in Excel and want to subtract only one value from other multiple cells, then they can use the Paste Special feature for doing the subtraction. So, for solving the calculation from this method, you need to follow the steps given below.

1. Right-click on the desired cell you want other cells to be subtracted from.

2. Click on Copy from the context menu.

Select the cell you want other cells to be subtracted from and Copy the selected Cell. | How to Subtract Multiple Cells in Excel

3. Select the range of cells you want to be subtracted.

Select the range of cells you want to be subtracted.

4. Right-click in the selected range.

5. Click on the Paste Special option.

Double-click in the selected range and Click on Paste Special Option.

6. Then, click on the Subtract option.

7. Click on OK to apply the changes.

A dialog box will appear, choose to Subtract option and Click on the Ok button. | How to Subtract Multiple Cells in Excel

Now, the subtraction of multiple values has been done from the first cell you selected and copied. The whole range of cells has been subtracted from the first cell.

Also Read: How to Split Excel File into Multiple Files by Row

How Do You Subtract 20 Cells in Excel?

Those who want to subtract 20 cells in Excel can apply the easiest method from which you can get your answer. For example, if there is an income of 40,000 and you want to deduct your expenditure from your income, then you can use the steps given below.

You can subtract the 20 cells in Excel by all three methods that are discussed above as they all will work for 20-cell subtraction, and if you want to subtract multiple cells from a single cell, then you can use the third method of paste special feature.

How to Add Multiple Cells in Excel

Doing an addition of multiple cells in Excel is also very simple and easy. You can do it quickly from the formula and without the formula is the easiest method.

Method 1: Use Addition (+) Symbol

This is the easiest method to do the calculation of how to add and subtract multiple cells in Excel. This method is the same as we do subtraction from Method 1 above. We just need to modify some minor changes. We need to insert plus (+) symbol and the addition will be done of multiple cells in just the easiest way, as shown below.

Insert plus sign instead of minus sign.

Also Read: How to Calculate Z Score in Excel

Method 2: Use SUBTOTAL Function

The steps for doing addition by using the subtotal function are given below:

1. Insert = symbol into the cell.

2. Type SUBTOTAL.

3. Insert the values in the bracket ().

4. Enter the value 9 which is the Sum function.

5. Insert comma (,) after the value 9.

6. Select the range of the cell.

7. Press the Enter key.

Insert equal to sign into the cell and Type SUBTOTAL and then Insert the values in the bracket and Give the Value 9 which is the Sum function Insert a comma after the value 9 and Select the range of the cell after that Press Enter. | How to Subtract Multiple Cells in Excel

This is the way you can do all calculations and you are now able to know how to add and subtract multiple cells in Excel. Also, the same methods for subtraction and addition apply to Google Sheets.

Recommended:

We hope that you learned how to subtract multiple cells in Excel. Feel free to reach out to us with your queries and suggestions via the comments section below. Also, let us know what you want to learn about next.

Leave a Comment

Your email address will not be published. Required fields are marked *