Hello everyone!

I need help with this situation.

From cells with text followed with (number) I would like to extract just the number value to be able to sum in a new column.

See the example of what Im looking to do it.

Thank you very much!