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)