I've been searching all over for a solution to this problem. Found bits and pieces of helpful formulas but none that did exactly what I wanted.
For a cell that has multiple numbers in parentheses, is there a formula to sum them all? For example:
Cell A1
x (80), y (50), z (100)
I'd like to get a formula that would sum the numbers in A1 to get 230. There could be anywhere from 1 to 10 numbers in parentheses in each cell.
There are also cases where there are numbers not in parentheses, which I would want to ignore:
Cell A1
x (80), y x3 (50), z x2 (100)
Again, I'd like to get a sum of 230.
Is this something that is possible?
For a cell that has multiple numbers in parentheses, is there a formula to sum them all? For example:
Cell A1
x (80), y (50), z (100)
I'd like to get a formula that would sum the numbers in A1 to get 230. There could be anywhere from 1 to 10 numbers in parentheses in each cell.
There are also cases where there are numbers not in parentheses, which I would want to ignore:
Cell A1
x (80), y x3 (50), z x2 (100)
Again, I'd like to get a sum of 230.
Is this something that is possible?