|As I said in my first response, you cannot do this in one step. You first need to convert all of the numbers/text to numbers and then add the resulting numbers.|
For example, if your data is in A1:L1. you need to put the "extraction formulas" someplace else, for example in A2:L2 or Row 1 of another sheet or something like that.
In other words, you have to extract all the numbers on a cell by cell basis and then sum the results. You can't perform the extraction and summing with one single formula.
So, if your data is in A1:L1, put this in A2 and drag it over to L2:
What this should do is check for a ( in each cell. If it doesn't find one, then ISERROR will return TRUE and just the number will be returned. If it does find a (, then it will strip off the ( and everything after it, leaving just the number.
Once you have a row full of extracted numbers, you can then sum them.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.