Best way to auto Sum cells with both numbers and text?
Hi everyone -
So i am trying to find a way to sum values in cells containing both number and text like "1 Macbook Pro, 2 Lenovo Tiny PC, etc. and give me the total for each item type in the totals column.
Please see the screenshot of my example smartsheet.
All of the column values are drop-down list of things we usually rent from our vendor. Usually i just manually add everything like i did in the example, but sometimes these sheets can get very long and you have to manually go through count and check everything multiple times.
So just wondering whats good way to accomplish this.
Help Article Resources
Check out the Formula Handbook template!