How to calculate a running total in ExcelĪs mentioned previously, there are multiple ways to calculate running totals in Excel, depending on the complexity of the situation on hand and the usage. To find out the remaining credit limits available, drag down the formula in D3 and apply it to the rest of the cells under column D.įrom the formulas, you can tell that each value of the running total takes reference from the previous value of running total and adds on the value of the new item.īelow is the full picture, with running total detailing the movement of the credit limit with each item added on. Now Cell D3 indicates the credit limits after deducting the expense from Whole Foods - $4916. This is to add the beginning credit limit and the new item - an expense from Whole Foods. Given that running totals reveal the summation of the data as new items are added to the total mix, to keep the changes: To create a running total, click D2 and enter =C2, the beginning credit limit to start with. A running total helps keep track of the credit limit available and personal expenditures.
Below is a credit card statement with various expenses and credits in the list.
