How to get a sum when text is involved within a cell?

Hi guys!

I'm in need of some help. I'm trying to get a formula to get the sum of all those numbers within the () but I am not sure how to do so. There will be text in the cells and I'm trying to get a sum of all the numbers together (112 all together in this case)
Help would be very much appreciated!

Excel.png

IMO, the easiest way to handle this is to go back to the data entry step and enter the text and numbers in separate cells (Test in column A and +5 in column B, for example).

If you are required to enter the data in this way, or you have no control over the data entry/import step, then you will need to do something to separate the number from the text. Assuming the plus character is the consistent indicator of the desired number and that the number is the final part of the text string.

1) A FIND() function to find the position of the "+" character https://support.microsoft.com/en-us/...3-d0d89b0a0628 FIND("+",A2)
2) Get the total length of the text string using the LEN() function LEN(A2)
3) The difference between the length and the location of the + is the number of characters that are the number, which you can use in a MID() function to extract the number as text. MID(A2,FIND(...),LEN(A2)-FIND(...))
4) Finally, a VALUE() function (or equivalent) to convert the number stored as text to a real number =VALUE(MID(...))

Enter that into the adjacent column (column B, assuming your picture represents columns A and B).

5) At the bottom of the helper column, enter your SUM() function =SUM(B2:B6)

Will something like that work for you?

Interesting. I had not heard that Excel supported regular expressions in any of its built in functions. I see regexextract() in Google Sheets list of available functions, but I don't see any indication from MSFT that Excel supports this function. Can I ask, for my own edification, if this is really an Excel function, or are you using this in Google Sheets?

@Djago

Please update your profile to show Google Sheets instead of Excel. Our helpers tailor their responses based upon the operating versions you are using.