How to get sum of numbers in one cell google sheets

user_6074210 0
Viewed 72

I need to sum up all values in one cell and get the total result. Note that there is also text in parenthesis as well. Here in the picture I need to know the Total for "Lenovoenter image description here"

office365 spreadsheet google-sheets excel-formula excel
1 Answers

You can use:

=SUM(SPLIT(REGEXREPLACE(B2, "[^\d\.]+", "|"), "|"))

enter image description here

user_95386840
Related