Excel Tip Add Cumulatively
343 views
·
Oct 25, 2022
****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com
Do you want become an expert in Excel?.
Then take a look at Mynda Treacy's Excel Expert course. The Link is here..http://www.mothresource.com/152-8-3-11.html
****Other Places You Can Find Me For More Excel Tips***
++Website http://www.howtoexcelatexcel.excel.com
++Twitter https://twitter.com/howtoexcelatex
++Pinterest http://www.pinterest.com/howtoexcelat
Today let’s look at adding a column of values so they add cumulatively or sometimes known as a running total.
The formula for this is fairly simple.
=Sum(C$4:C4)
You can hit ALT= for a quick Autosum or type = in the cell or the formula bar. We need to lock down the first part of the formula C$4 so that as the formula is filled in down the column the formula expands down the column, but the first reference remains locked at C$4.
Once the formula is entered, double click or drag to fill the formula down the column. East as that. A cumulative total.
Show More
Show LessComments
loading text loading
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text