Microsoft Excel is highly effective spreadsheet software program. It comes with numerous options like calculation formulae or instruments, graphing instruments, pivot tables, and so forth. These options make it simpler for a consumer to manage and handle knowledge. Typically, we want to subtract a single worth from completely different values or a variety of values from a single worth in Excel. If you already know the shortcut methodology to do that, it can save you your time, in any other case, the calculation might be time-consuming. On this article, we’ll present you how to subtract multiple cells in Excel.
How to subtract multiple cells in Excel
We’ll see right here how to subtract multiple cells from one cell in Microsoft Excel:
- Through the use of a system
- Through the use of the SUM operate
- With out utilizing a system
Let’s see all these strategies in element.
1] How to subtract multiple cells in Excel through the use of a system
Right here we’ll speak about how to subtract knowledge organized in multiple cells in a selected row and column from a single cell in Excel.
Within the above screenshot, you’ll be able to see pattern knowledge organized in completely different rows and columns. On this instance, we’ll subtract multiple cells in a selected row from a single cell. Right here, we’ll subtract the values in cells B1, C1, D1, and E1 from cell A1.
To take action, we’ll use the minus signal in our system. To subtract the cells B1, C1, D1, and E1 from cell A1, you’ve to write the next system in the cell in which you need to show the consequence and press Enter. Right here, we’re going to show the consequence in cell F1.
=A1-B1-C1-D1-E1
You may copy the identical system to different cells by dragging the primary cell. For instance, if I would like to copy the system typed in the F1 cell to different cells in the F column, I’ll merely drag the F1 cell to the opposite cells in the F column.
You should utilize the identical system to subtract multiple numbers organized in a column. Let’s say you need to subtract your expenditures out of your revenue. Right here, we’ve taken the same instance in which cell B1 reveals whole revenue, cells B2 to B6 present the quantity spent on completely different gadgets, and cell B7 reveals the remaining quantity.
To subtract cells B2 to B6 from cell B1, enter the next system in the cell B7 and hit Enter:
=B1-B2-B3-B4-B5-B6
Learn: How to create a Half Pie Chart in Excel.
2] How to subtract multiple cells in Excel through the use of the SUM operate
It’s also possible to use the SUM operate to subtract multiple cells from a single cell in Excel. This system works for knowledge organized horizontally in addition to vertically in Excel.
Let’s take the identical instance of revenue and expenditure in which cell B1 reveals revenue and cells B2 to B6 present expenditures, then the system to calculate the remaining quantity is as follows:
=B1-SUM(B2:B6)
3] How to subtract multiple cells in Excel with out utilizing a system
You may subtract multiple cells in Excel through the use of the Paste Particular function. However this trick works solely when you have to subtract just one worth from multiple cells. Let’s see how to try this.
Within the instance that we’ve taken right here, we’ll subtract the worth in cell B2 from the values in cells A2 to A8. Right here, the consequence after subtraction might be displayed in the identical cells (A2 to A8).
The next directions will information you on how to subtract a single cell from multiple cells in Excel through the use of the Paste Particular function.
- Copy the cell the worth of which you need to subtract from the opposite cells.
- Choose the cells from which you need to subtract the worth.
- Proper-click on the chosen cells after which click on on the Paste Particular possibility. This may open the Paste Particular window.
- Within the Paste Particular window, choose Subtract after which click on OK.
After that Excel will delete cell B2 from cells A2 to A8 and show the consequence in the identical cells (A2 to A8).
Learn: How to cease Excel from rounding numbers.
How do you subtract a variety of cells in Excel?
You may subtract the vary of cells in Excel through the use of the minus (-) signal or through the use of the SUM operate. Let’s say, you need to subtract the cells B2 to B10 from the cell B1, then the system must be this:
=B1-B2-B3-B4-B5-B6-B7-B8-B9-B10
If you don’t want to kind such an extended system, you should use the SUM operate for a similar. Should you use the SUM operate, you’ve to kind the next system:
=B1-SUM(B2:B10)
How do you subtract 3 cells in Excel?
If you would like to subtract 3 cells in Excel, you’ll be able to both use the minus (-) signal in your system or use the SUM operate. Each the formulae are as follows:
A1-A2-A3 A1-SUM(A2:A3)
The above system is used to subtract cells A2 and A3 from cell A1. Should you use the minus signal in the system, you’ve to kind every cell individually in the system. This makes the system longer for the longer vary of cells. Then again, when you use the SUM operate, you simply have to enter the primary and the final cell separated by a colon. This makes the system shorter irrespective of how lengthy is the vary of cells you need to subtract.
That’s it.
Learn subsequent: How to Create an Group Chart in Microsoft Excel.
