Calculating cumulative totals

In this video you will learn how to quickly sum up values through using the cumulative totals in Microsoft Excel.

This simply refers to the summing up of values via the tallying of data as it enters into the system in Microsoft Excel. You can use the function when calculating cumulative values in your excel worksheet. In order to get started I have already navigated to this page by clicking on the Home tab in Microsoft Excel.

To obtain the cumulative totals for the current data I click on the first cell under the Total column then I type in the first value from the values column. The cumulative function appears from the second value so in order to do this I type in my formula then I select the sum function from the drop down list with excel suggestions. I then click on the first cell under values and drag down to the second cell in the same column then I click back on the second cell under total where I have my formula then I freeze the first cells so that the formula can be applied to all the cells then I close the bracket and press on the enter key on my keyboard.

As you can see, the figure in the second cell under the Total column is the sum of 20,000 and 15,000. To apply this formula to the rest of the cells I click on the plus sign at the bottom of the cell where I have put the formula and drag it downwards to the end of my data set. As you can see, the cumulative totals for my data set have been calculated.