Excel to Ignore Text and Sum Values

[nfordhk]

Hi,

I know this has been asked a few times but I am struggling if anyone can help. I have a CSV file with sample text below. I need to sum the values within the parenthesis down the columns.

Column A          Column B
10.25.4.0/23	14.1% (33/234)
10.25.6.0/23	9.8% (23/234)
10.25.8.0/24	18.3% (22/120)
10.25.9.0/24	0.0% (0/231)
10.25.10.0/23	4.0% (10/244)

Looking to create this output
Total                 (88/1063)

We are summing the first portion down all columns and the second.
(33 + 23 + 22 + 0 +10) / (234 + 234 + 120 + 231 + 244)