How do I sum multiple values in a cell. When I use the column Number, I could only insert one value into the form when I need to insert multiple values. When I do the text format, there is an apostrophe that blocks me from getting the sum. Reason why I am asking is because I am working on a project that gets the weight of multiple items in one cell separated by a comma, and I need to find the total weight from these separated values.
User | Count |
---|---|
17 | |
11 | |
7 | |
4 | |
3 |