# I need help adding all of the assets from a column for every row

Options

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.

• ✭✭✭✭✭✭
Options

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])

Options

You are unbelievable it worked dollar sign and comma's. I cannot thank you enough for your help on this,

Have great weekend.

• ✭✭✭✭✭✭
Options

Are you able to provide a screenshot with manually entered mock data that shows what you are trying to accomplish?

• Options

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.

• ✭✭✭✭✭✭
Options

Where exactly are you wanting this formula?

• Options

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.

• ✭✭✭✭✭✭
Options

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])

• Options

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.

• ✭✭✭✭✭✭
Options

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 \$.

Options

You are unbelievable it worked dollar sign and comma's. I cannot thank you enough for your help on this,

Have great weekend.

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!