**Microsoft Excel** allows us to estimate different types of data and carry out monetary, mathematical, and statistical computations. You can manipulate numbers with **Excel** by adding large columns of numbers, calculating percentages, or creating graphs and charts. **Excel** spreadsheets can also be used to create a running total by subtraction using a simple formula. In this article, you will learn how you can get a running total by subtraction in **Excel**. Now let’s get started!

**Table of Contents**hide

**Download Practice Workbook**

You can download the practice workbook here:

**How to Get a Running Total by Subtraction in Excel (2 Easy Methods)**

To demonstrate how to create a running total by subtraction using a simple formula, I have taken a concise dataset of **11 rows** and **6 columns,** which are **Region**, **Rep Name**, **Item**, **Units**, **Unit Cost** and **Total**. In this article, we are going to use the ** Excel 365 version**. You can use any other version according to your convenience.

Now, let’s go through the following part of this article.

**1. Using Basic Subtraction Formula in Excel**

In this method, we are going to use the basic subtraction formula, also known as the minus formula, to create a running subtraction total in **Excel**. To do this, I have added a new column named **Running Subtraction Total,** where I will show the running subtraction total. Let’s go through the below steps.

📌 **Steps**:

- Enter the starting value of
**$6,860**in cell**H5**. - In cell
**H6**, enter the formula:**=H5-G6**and press**Enter**.

Now, copy the formula to the lower cells to create a** running total**.

- Click on cell
**H6**. - Move the
**cursor**to the bottom right corner, then**click**and**drag**the cell downward to drag the formula down the column.

This will automatically update the cell references in the formula to reflect the relative position of each cell. So you won’t have to rewrite the formula for each cell.

**Read More: ****Quick Analysis Tool: Calculation of Running Total in Excel (4 Ways)**

**2. Using the SUM Function to Create a Running Subtraction Total**

In this method, we will use **the SUM function** to create a running subtraction total in Excel. You can do this by following the easy steps below.

**📌Steps:**

- Enter the starting value of
**$6,860**in cell**H5**. - In cell
**H6**, enter the formula:**=SUM(H5-G6)**and press**Enter**.

Now, copy the formula to the lower cells to create a running total.

- Click on cell
**H6**. - Move the
**cursor**to the bottom right corner, then**click**and**drag**the cell downward to drag the formula down the column.

This will copy the **SUM** formula to the lower cells, so you won’t have to rewrite the formula for each cell.

**Read More: ****Cumulative Sum in Excel If Condition Applied (6 Methods)**

**How to Subtract Percentage in Excel**

If you want to simply subtract one percentage from another, you can use the well-known minus formula. That will work perfectly. To show this, I have added 3 new columns named **Total Work**, **Accomplished,** and **Remaining**. The **Remaining **column is the result column.

Now follow the below steps.

📌**Steps**:

- In cell
**J5**, enter the formula:**=H5-I5**and press**Enter**.

Now, copy the formula to the lower cells to subtract the percentage.

- Click on cell
**J5**. - Move the
**cursor**to the bottom right corner, then**click**and**drag**the cell downward to drag the formula down the column.

This will copy the formula to the lower cells, so you won’t have to rewrite the formula for each cell.

**Read More: ****How to Calculate Running Total in One Cell in Excel (5 Ways)**

**How to Subtract Dates in Excel**

Suppose you want to subtract dates from your dataset. The simplest way to subtract dates in Excel is to enter them individually in separate cells and subtract one from the other. The syntax will be:

`=End_date - Start_date `

To demonstrate the process, I have added 3 new columns named **Order Date**, **Delivery Date,** and **Duration(Days)**. Here, the **Duration(Days) **column is the result column. Now follow the below steps.

📌 **Steps**:

- In cell
**J5**, enter the formula:**=I5-H5**and press**Enter**.

Now, copy the formula to the lower cells to subtract dates like the previous methods.

**Read More: ****How to Use Pivot Table to Calculate Running Total by Date in Excel**

**How to Subtract Time in Excel**

If you want to subtract time in Excel, you can do that too. The formula for subtracting time in Excel is built in a similar way. The syntax is:

`=End_time-Start_time`

I have added **3** new columns named **Start Time**, **End Time,** and **Elapsed Time**. Here, the **Elapsed Time **column is the result column. Now follow the below steps.

📌 **Steps**:

- In cell
**J5**, enter the formula:**=I5-H5**and press**Enter**.

Now copy the same formula to the lower cells to subtract times so you won’t have to rewrite the formula for each cell.

**Read More: ****How to Calculate Running Total by Group Using Excel Power Query**

**How to Do Matrix Subtraction in Excel**

In this part of the article, I will show you how you can do matrix subtraction when you have two sets of values (matrices).

I have **two** matrices named **Matrix 1** and **Matrix 2**. I have another matrix named **Result** to show the output after subtraction.

Now follow the below steps accordingly.

📌 **Steps**:

- Insert the normal subtraction formula (
**=B5-F5**) in the top leftmost cell which is**D10**. - Now drag it to the next
**2**columns and**2**rows.

You can copy rightward and downward to as many cells as your matrices have rows and columns.

Here is the final output matrix after subtracting **Matrix 1** and **Matrix 2**.

**Read More: ****How to Calculate Horizontal Running Total in Excel (3 Easy Ways)**

**Frequently Asked Questions**

**How do I subtract multiple cells from a total in Excel?**

You can **subtract multiple cells** from a total in **Excel** as well. I hope the attached article from **ExcelDemy** will help you get your answer.

**How do you add and subtract totals in Excel?**

Yes, you can **add and subtract** totals in **Excel** easily. The attached article will help you get a clear understanding of this issue.

**Key Takeaways from the Article**

- In this article, I have shown how to create a running total by subtraction in
**Excel**. - A chosen real-life dataset for better understanding.
- Focusing on how to create a running total by subtraction with some easy ways in
**Excel**. - Explained different subtracting approaches with
**Excel**. - Showed how to subtract time and date in
**Excel**. - Provide solutions to frequently asked questions of readers.
- Overall, focused on creating a running total by subtraction in
**Excel**.

**Conclusion**

In this article, I’ve explained how to quickly create a running total in **Excel** by subtracting. This will help you work faster and more efficiently. I hope you found this article informative and enjoyable. For more **Excel** and **Excel VBA-related** articles, visit **ExcelDemy**. Let me know in the comments section if you have any questions, comments, or recommendations.