For checking the correctness of the results you can see that the running total for December contains the sales records from January to December. ➤ Select the Running Total option with a symbol having a yellow highlighted color from here because it will give the results in a new column at the end of each row.Īfter that, you will get the running totals in the Running Total column for each month.

➤ Click on the indicated symbol on the right side to explore more options.įinally, you will have the rest of the options for Totals. Now, you will see different types of totals here for calculating. Then, you will have different options under the Quick Analysis Tool.

Click on this symbol or you can press CTRL+Q also. ➤ Select the range, and then, you will see the Quick Analysis symbol on the bottom right corner of the range. Here, we have the sales records for 12 months for a product Orange, and using the Quick Analysis Tool we will calculate the running total for this product for different months in a new column Running Total. Method-1: Calculation of the Running Total for a Single Column Using Quick Analysis Tool We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience. We will try to show the ways of calculating the running total for a single product and multiple products, and even we will calculate it by transposing the columns into rows also. Here, we have the sales records for 12 months for the products Orange, Apple, and Cherry. Running total is the cumulative sum of the range from the starting value to the corresponding cell value. 4 Ways to Calculate Running Total in Excel with the Help of Quick Analysis Tool

Quick analysis button excel 2007