Running total cost

snhawkin ✭

11/15/23 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?

Tags:

• Formulas
• Community Platform
• Smartsheet

0 · Share on FacebookShare on Twitter

Best Answer

• 

  KPH ✭✭✭✭✭✭

  11/15/23 Answer ✓

  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)

  1 · Share on FacebookShare on Twitter

Answers

• 

  KPH ✭✭✭✭✭✭

  11/15/23 Answer ✓

  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)

  1 · Share on FacebookShare on Twitter
• 

  snhawkin ✭

  11/15/23

  https://community.smartsheet.com/discussion/comment/405147#Comment_405147

  thank you!!! @KPH

  0 · Share on FacebookShare on Twitter
• 

  KPH ✭✭✭✭✭✭

  11/15/23

  Happy to help @snhawkin

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list