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)
Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Running total cost
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?
Best 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)
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!