The simplest way to subtract dates in Excel is to enter them individually in separate cells and subtract one from the other. Suppose you want to subtract dates from your dataset. Read More: How to Calculate Running Total in One Cell in Excel (5 Ways) This will copy the formula to the lower cells, so you won’t have to rewrite the formula for each cell. Now, copy the formula to the lower cells to subtract the percentage.

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

The Remaining column is the result column. To show this, I have added 3 new columns named Total Work, Accomplished, and Remaining. If you want to simply subtract one percentage from another, you can use the well-known minus formula. Read More: Cumulative Sum in Excel If Condition Applied (6 Methods) This will copy the SUM formula to the lower cells, so you won’t have to rewrite the formula for each cell.

In cell H6, enter the formula: =SUM(H5-G6) and press Enter.

You can do this by following the easy steps below. In this method, we will use the SUM function to create a running subtraction total in Excel. Using the SUM Function to Create a Running Subtraction Total Read More: Quick Analysis Tool: Calculation of Running Total in Excel (4 Ways)Ģ. So you won’t have to rewrite the formula for each cell. This will automatically update the cell references in the formula to reflect the relative position of each cell.

Move the cursor to the bottom right corner, then click and drag the cell downward to drag the formula down the column.

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

In cell H6, enter the formula: =H5-G6 and press Enter.

Enter the starting value of $6,860 in cell H5.

To do this, I have added a new column named Running Subtraction Total, where I will show the running subtraction total. 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.

Now, let’s go through the following part of this article.ġ. You can use any other version according to your convenience. In this article, we are going to use the Excel 365 version. 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.

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

Subtraction in excel formula