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.

Please Login or Register  to view this content.

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...?

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

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)))&")"