I need help adding all of the assets from a column for every row
I want to calculate my potential assets column for every row I have now and for any I add or subtract. So it adds it up below the last row that has data. I am not good at formulas, I am new to smart sheets and greatly appreciate any help, Thank you.
Best Answers
-
Ok. In that case you would want to put it in a different column or in a Sheet Summary field and use:
=SUM([Potential Assets]:[Potential Assets])
-
You are unbelievable it worked dollar sign and comma's. I cannot thank you enough for your help on this,
Have great weekend.
Answers
-
Are you able to provide a screenshot with manually entered mock data that shows what you are trying to accomplish?
-
Here is a mock version but I have like 25 rows and that could go up and down weekly. So the formula would obviously have to be for all rows in that column. Thank you for your help, let me know if this is what you meant.
-
Where exactly are you wanting this formula?
-
Doesn't really matter I just want to see a total somewhere of all of the potential assets. I am not really sure what would work or how to do it. I am not picky first row last row or a separate column what ever is the easiest. Again thank you for your assistance.
-
Ok. In that case you would want to put it in a different column or in a Sheet Summary field and use:
=SUM([Potential Assets]:[Potential Assets])
-
Awesome that formula did work in a separate column so thank you. If it is not too much to ask is there a way to add comma's, and a dollar sign to the formula? example the formula you gave me adds it like 7000000 as opposed to $7,000,000 it is not a huge deal but if it is a minor adjustment to the formula it would look cleaner. I am trying to learn how to do the sheet summary field, but this will work fine again thank you so much for your help it is amazing how helpful everyone is in this community.
-
You should be able to click on the three dots on the right of the top toolbar to get additional options and then click on the $.
-
You are unbelievable it worked dollar sign and comma's. I cannot thank you enough for your help on this,
Have great weekend.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!