Running Total

Do you want to see an up to date Product Sales list as you transact every day. Then using a running total is the solution to your problem. A running total is the summation of a sequence of numbers which is updated each time a new number is added to the sequence, simply by adding the value of the new number to the running total.

Below we demonstrate how to add a Product Sales Running Total.

 Applies To: MS Excel 2010 

  1. Select cell E2 as per screen shot above
  2. Enter the following formula :  =SUM($D$2:D2)
  3. Select the data range E2:E24
  4. Select the Home Tab-Editing group
  5. Then select as per screen shot below

6.  The Product Sales  Running Total will be as below


If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations