Running total cost

Options
snhawkin
snhawkin ✭
in Formulas and Functions

I am trying to utilize a sheet for cost tracking. I have a column where the dollar amounts are being put in, how can I just have the value of the column to keep a running total?



Capture.PNG


Tags:
· Share on FacebookShare on Twitter

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    You can use a SUM formula to calculate the total of the values in the column where your dollar amounts are entered. Put this wherever you want the total to appear. It will sum all the values in the COSTS column.

    =SUM(COSTS:COSTS)

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!