Adding values in brackets

[HXIO]

Hi,

In a column I've values like below.

Please Login or Register  to view this content.

What I want to achieve is to add the values in the brackets in column T like below,

Please Login or Register  to view this content.

Thanks

[Glenn Kennedy]

So... is your expected result 354, or the string 15+56+103+90+45+45 ???

[HXIO]

@Glenn Kennedy

The expected values I want in column T would be the string 15+56+103+90+45+45

[Bo_Ry]

Assume that data is at A1

Not sure you will like this but, please try B1 drag to the right

=IFERROR(REPLACE(A1,FIND("(",A1),FIND(")",A1)-FIND("(",A1)+1,SUMPRODUCT(--MID(SUBSTITUTE(MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1),"+"," "),{1,5},5))),"")

[HXIO]

@Bo_Ry

I've try your formula but I can't seem to get it to work.

When you said B1 drag to the right do you mean down instead?

[Bo_Ry]

HXIO,

Your files is a lot more complex than you Post#1,

Please see attached,
This method require many helper columns. I have to shift final result to columns U.

[HXIO]

@Bo_Ry

Thanks for the help care for an explanation of the formula on how it works if possible?

Thanks

[shg]

UDF?

	A	B	C
1	Input	Output
2	17+(11+78+38)+(74+74)+(54+78)+66+33	17+127+148+132+66+33	B2: =Debracket(A2)
3	17+66+107+108+50+17+8	17+66+107+108+50+17+8
4	15+26+57+54+43+37+8	15+26+57+54+43+37+8
5	27+53+(72+34)+(72+33)+77+27+14	27+53+106+105+77+27+14
6	33+(84+15)+79+50+33+16+16	33+99+79+50+33+16+16
7	10+20+30+37+37+20+10	10+20+30+37+37+20+10
8	10+23+45+55+23+10+10	10+23+45+55+23+10+10
9	22+22+86+88+66+44+22	22+22+86+88+66+44+22
10	120+136	120+136
11	22+66+(64+66)+(64+24)+44+44+22	22+66+130+88+44+44+22
12	(44+18)+(38+38+38+16)+(36+36+36+23)+(24+36+36+36)+(32+18)+17	62+130+131+132+50+17
13	27+(30+30+22)+(30+30+30+30+15)+(30+30+30+30+17)+(30+24)+27	27+82+135+137+54+27
14	31+(41+37+23)+(66+66+11)+(66+66+13)+(15+60)+19+10	31+101+143+145+75+19+10
15	54+96+(102+54)+(78+84)+84+42+30	54+96+156+162+84+42+30

Please Login or Register  to view this content.

[Bo_Ry]

I would use shg's UDF.

Formula is too complicate, find brackets, extract text in brackets, separate text in brackets with "+" and sumproduct # in brackets then replace it back to brackets, and this only for first set of brackets. Next column is for 2nd set of brackets and so on.