To use this method, you need two simple formulasįirst, enter this formula into C2 (using the example above)įinally, copy and paste the formula from C3 into C4, C5, C6 and so on down the column. ![]() Option 1 - create a simple addition formula in the second row, and copy it down the column You want to put a running total of sales (column B) in column C:Īs you can see, column C shows the cumulative running total of the sales in column B. Imagine your spreadsheet has values in cells A2 through to B16. You can write a formula using the SUM() function which utilizes absolute and relative references. ![]() ![]()
0 Comments
Leave a Reply. |