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.

**Table of Contents**hide

## 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 R**elative Cell References.** Let me show you how to do that.

❶ At first insert the following formula in cell **E5**.

`=C5-D5`

Here, **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:C14`

Here, 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.