How to sum up multiple costs in same cell?

Hi, I have created this form where I am able to input multiple items in a same cell. However, I want to sum up the multiple quantity of the same cell. Is there any formula or function I am able to do so? Or is it possible to split the different item to different row but form ID remains the same?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!