Mrinmoy Roy
Subtraction is quite a frequent task that we need to perform in Excel. There are multiple ways available to subtract from a total in Excel. In this article, you will learn 3 quick methods to subtract in Excel from a total with ease.
Download Practice Workbook
You can download the Excel file from the following link and practice along with it.
3 Methods to Subtract from Total in Excel
1. Subtract from a Total in Excel Using Relative Cell Reference
You can directly subtract from a total using a formula with the Relative Cell References. Let me show you how to do that.
❶ At first insert the following formula in cell E5.
=C5-D5Here, C5 has an amount of Total Revenue and D5 has an amount of Total Expense.
❷ Then press ENTER.
❸ After that, drag the Fill Handle icon from cell E5 to E12.
So, you’ve successfully subtracted Total Expense from Total Revenue.
Read More: Subtraction for Whole Column in Excel (with 5 Examples)
2. Using Absolute Cell Reference to Subtract from a Total
If you have a total amount in a specific cell from where you need to subtract, then you can use the Absolute Cell Reference to subtract from the total amount.
In this case, the Total Revenue is in cell C4. The Total Expense amount is stored from cells C7 to C14.
Now follow the steps below to subtract.
❶ First, insert the following formula in cell D7.
=$C$4-C7:C14Here, the dollar sign ($) is applied in cell C4 to make it an Absolute Cell Reference. C7:C14 refers to all the cells from C7 to C14 having the Total Expense.
❷ Now press ENTER.
As we have used a range in the formula, cells D7 to D14 will be automatically filled with the subtraction result from the Total Revenue.
Read More: How to Subtract in Excel Based on Criteria (3 Suitable Examples)
Similar Readings
- Subtract Two Columns in Excel (5 Easy Methods)
- How to Subtract Multiple Cells in Excel (6 Effective Methods)
- How to Subtract Columns in Excel (6 Easy Methods)
3. Subtract from a Total in Excel Using SUM Function
We can also use the SUM function to subtract the Total Expense from the Total Revenue.
Now follow the steps below:
❶ First, insert the following formula in cell E5.
=SUM(C5-D5)Here, cell C5 has the Total Revenue amount and cell D5 has the Total Expense amount.
❷ Now press ENTER.
❸ Drag the Fill Handle icon from cell E5 to E12.
So, you have successfully subtracted the Total Expense from the Total Revenue using the SUM function.
Read More: Subtraction Formula in Excel (7 ways)
Practice Section
You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the methods discussed in this article.
Conclusion
To sum up, we have discussed 3 methods to subtract from a total in Excel. You are recommended to download the practice workbook attached with this article and practice all the methods. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website ExcelDemy to explore more.
