Excel to Ignore Text and Sum Values

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)

Does this work for you...?

      --------A-------- ------B------- --C--- -----D-----
  1   Column A           Column B                        
  2   10.25.4.0/23      14.1% (33/234) 33/234          88
  3   10.25.6.0/23      9.8% (23/234)  23/234        1063
  4   10.25.8.0/24      18.3% (22/120) 22/120 0.082784572
  5   10.25.9.0/24      0.0% (0/231)   0/231             
  6   10.25.10.0/23     4.0% (10/244)  10/244

C2: =MID(B2, FIND("(",B2)+1, FIND(")",B2) - FIND("(",B2) - 1) >> Copied down
D2: =SUMPRODUCT(--(LEFT(C2:C6,FIND("/",C2:C6)-1)))
D3: =SUMPRODUCT(--(MID(C2:C6,FIND("/",C2:C6)+1,LEN(C2:C6))))
D4: =D2/D3

This is an array formula: **Must be entered with Ctrl+Shift+Enter key combination.

Formula:

="("&SUM(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1:B5,"(","/"),")","/"),"/",REPT(" ",50)),50,50)))&"/"&SUM(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1:B5,"(","/"),")","/"),"/",REPT(" ",50)),100,50)))&")"

v	A	B
1	10.25.4.0/23	14.1% (33/234)
2	10.25.6.0/23	9.8% (23/234)
3	10.25.8.0/24	18.3% (22/120)
4	10.25.9.0/24	0.0% (0/231)
5	10.25.10.0/23	4.0% (10/244)
6
7		(88/1063)
8

The array formula helped me parse everything which is great but now I thought I'd be able to perform the auto sum. It doesn't add correctly though.

Now my columns look like this

COLUMN A                 COLUMN B               COLUMN C
10.172.161.0/24	           20.0% (8/40)	              (8/40)
10.172.162.0/24	            5.0% (10/200)	      (10/200)
10.172.163.0/24	            0.0% (0/0)	              (0/0)
10.172.164.0/23	            58.0% (259/446)         (259/446)

I'm having trouble expanding to all my columns, is there a limitation?

="("&SUM(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1:B1436,"(","/"),")","/"),"/",REPT(" ",50)),50,50)))&"/"&SUM(--TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1:B1436,"(","/"),")","/"),"/",REPT(" ",50)),100,50)))&")"

I also tried putting the array in the row underneath everything but I just get a #VALUE