CODEWITHSUNDEEP
excelgoogle-sheetsexcel-formulaoffice365spreadsheet
Ilgar Safarli
Ilgar Safarli

Reputation: 71

How to get sum of numbers in one cell google sheets

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"

Upvotes: 1

Views: 378

Answers (1)

Nabnub
Nabnub

Reputation: 1055

You can use:

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

enter image description here

Upvotes: 4

Related Questions