Calculating with a formatted cell

Good morning,

How can I use the numbers in () to calculate a value in another cell?

For example:

I am tracking the number of singles, doubles, triples and homeruns in a baseball game.

I then want to see how many were hit over a 7 day period. So this is how the cells are setup


A B C (calculated cell)
1 Singles (5) 7 35
2 Doubles (2) 7 14
3 Triples (1) 7 7
4 Homeruns (1) 7 7

The formatting doesnt quite come across when I post this but basically the A-D above are the column headings and the 1-4 are the rows. The first line has "Singles (5)" in A1, "7" in B1 and "35" in C1.

If I have to, I can break the 1st column into two and put the number in the parenthesis in column B and slide B and C over to C and D.

Thank you!!!

If I understand corret, the formula shall extracts the number.

=--SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")
Substitute will take away the left and the right parentesis.
The double neg. (--) will transform the text value to a number value.
(5)-->5

Ola Sandström