Forum Discussion

dkgrant70's avatar
dkgrant70
Copper Contributor
Oct 12, 2022

Total calculated

I am creating a spread sheet of monthly payments made by different clients to the company. After creating a sheet for each month I need a running total calculated after each entry. How do I do this on a spread sheet?

excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Oct 13, 2022

    dkgrant70 

    Assuming your values to be summed are in column M from row 2, write the following function in a column of your choice in row 2:

    =SUM(M$2:M2)

    Now you can copy the formula down into the cells to get the running total.

Resources