Dear readers, today read in this article how to make a running total (cumulative sum) in Excel?

A total change occurs each time new data is added to a list.

First of all download excel demo file for running total in excel

Step 1. Select cell B9 and enter a simple SUM function.

Step 2. Select cell C2 and enter the SUM function shown below.
Step 3. Select cell C2, click on the lower right corner of cell C2 and drag it to cell C7.
Step 4. For example, take a look at the formula in cell C3.
Step 5. For example, take a look at the formula in cell C4.
Step 6. At step 2, enter the IF function shown below (and drag it down to cell C7) to display only a cumulative amount if the data has been entered.
Step 7. Enter sales in April.

Best understand through the excel snapshot

Running Total formula in excel