How to subtract multiple cells in Excel
Microsoft Excel is powerful spreadsheet software. It comes with various features similar adding formulae or tools, graphing tools, pivot tables, etc. These features arrive easier for a user to organize and manage data. Sometimes, nosotros need to subtract a single value from dissimilar values or a range of values from a single value in Excel. If yous know the shortcut method to do this, you can salvage your fourth dimension, otherwise, the calculation will be fourth dimension-consuming. In this article, we will show you how to decrease multiple cells in Excel.
How to decrease multiple cells in Excel
We will come across here how to decrease multiple cells from ane jail cell in Microsoft Excel:
- By using a formula
- By using the SUM part
- Without using a formula
Let's encounter all these methods in particular.
1] How to subtract multiple cells in Excel by using a formula
Here we volition talk most how to decrease data bundled in multiple cells in a item row and column from a single cell in Excel.
In the above screenshot, yous can see sample data bundled in different rows and columns. In this example, we will subtract multiple cells in a particular row from a single cell. Here, we will decrease the values in cells B1, C1, D1, and E1 from prison cell A1.
To exercise and then, we will utilise the minus sign in our formula. To decrease the cells B1, C1, D1, and E1 from prison cell A1, you have to write the following formula in the cell in which you want to display the result and press Enter. Here, we are going to display the result in cell F1.
=A1-B1-C1-D1-E1
You tin copy the same formula to other cells by dragging the first cell. For example, if I want to copy the formula typed in the F1 prison cell to other cells in the F column, I will just elevate the F1 cell to the other cells in the F column.
You can use the same formula to subtract multiple numbers arranged in a column. Let's say you want to subtract your expenditures from your income. Here, we take taken a similar example in which cell B1 shows total income, cells B2 to B6 show the amount spent on different items, and cell B7 shows the remaining amount.
To subtract cells B2 to B6 from cell B1, enter the post-obit formula in the cell B7 and hit Enter:
=B1-B2-B3-B4-B5-B6
Read: How to create a Half Pie Chart in Excel.
2] How to subtract multiple cells in Excel by using the SUM role
You can as well apply the SUM office to subtract multiple cells from a single cell in Excel. This formula works for data arranged horizontally every bit well equally vertically in Excel.
Let's accept the same example of income and expenditure in which jail cell B1 shows income and cells B2 to B6 show expenditures, then the formula to summate the remaining amount is as follows:
=B1-SUM(B2:B6)
three] How to subtract multiple cells in Excel without using a formula
Yous can subtract multiple cells in Excel by using the Paste Special feature. Just this trick works only if you accept to decrease simply 1 value from multiple cells. Let's encounter how to do that.
In the instance that nosotros have taken here, nosotros volition subtract the value in cell B2 from the values in cells A2 to A8. Hither, the result after subtraction volition be displayed in the same cells (A2 to A8).
The post-obit instructions will guide you on how to subtract a single jail cell from multiple cells in Excel by using the Paste Special feature.
- Copy the jail cell the value of which you desire to subtract from the other cells.
- Select the cells from which you lot want to subtract the value.
- Right-click on the selected cells and then click on the Paste Special option. This will open the Paste Special window.
- In the Paste Special window, select Subtract and so click OK.
After that Excel will delete prison cell B2 from cells A2 to A8 and display the consequence in the same cells (A2 to A8).
Read: How to stop Excel from rounding numbers.
How do you decrease a range of cells in Excel?
Y'all can subtract the range of cells in Excel past using the minus (-) sign or by using the SUM function. Let's say, yous want to subtract the cells B2 to B10 from the cell B1, and so the formula should be this:
=B1-B2-B3-B4-B5-B6-B7-B8-B9-B10
If you do non want to type such a long formula, you can use the SUM office for the same. If you lot use the SUM function, you have to type the following formula:
=B1-SUM(B2:B10)
How practice yous subtract 3 cells in Excel?
If you want to decrease 3 cells in Excel, you can either use the minus (-) sign in your formula or use the SUM function. Both the formulae are as follows:
A1-A2-A3 A1-SUM(A2:A3)
The above formula is used to subtract cells A2 and A3 from jail cell A1. If you utilise the minus sign in the formula, y'all have to type each cell separately in the formula. This makes the formula longer for the longer range of cells. On the other hand, if you lot utilise the SUM role, you lot just have to enter the first and the final cell separated by a colon. This makes the formula shorter no matter how long is the range of cells you lot desire to subtract.
That'due south information technology.
Read side by side: How to Create an Organization Nautical chart in Microsoft Excel.
Source: https://www.thewindowsclub.com/how-to-subtract-multiple-cells-in-excel
Posted by: mendeztiostiont.blogspot.com
0 Response to "How to subtract multiple cells in Excel"
Post a Comment