Extract and sum parts of strings in cells

[Formula11]

Is this possible with Excel formula (not Visual Basic).

Extract first number in blue cells and divide by second number.
Sum cells.

Output would be sum(0.25/0.025, 0.5/0.1, 0.4/0.02) = 35.

Number of cells is a variable.

 

[awoohaw]

try this:

Mr Excel Akbarov.xlsx
	A	B
1
2	(T)*(0.25)*(d/0.025)	35
3	(T)*(0.5)*(d/0.1)
4	(T)*(0.4)*(d/0.02)
formula11

Cell Formulas
Range	Formula
B2	B2	=SUM(TEXTAFTER(TEXTBEFORE(A2:A4,")",2),"(",2)/TEXTAFTER(TEXTBEFORE(A2:A4,")",3),"/"))

 

[Formula11]

Thanks awoohaw, this works quite well.

 

[awoohaw]

I am happy you found a solution. Thanks for the feedback.
Best Wishes!

 

[Formula11]

Is it possible to increase complexity of this awoohaw.

For the example below, I tried the formula, but doesn't work.

=SUM(TEXTAFTER(TEXTBEFORE(A2:A4,")",2),"(",2)/TEXTAFTER(TEXTBEFORE(A2:A4,")",3),"/"))
+SUM(TEXTAFTER(TEXTBEFORE(A2:A4,")",5),"(",5)/TEXTAFTER(TEXTBEFORE(A2:A4,")",6),"/"))

The issue I think is referencing the second "/".

 

[awoohaw]

So, a couple things I think are wrong.
You didn't repeat the formula exactly on the 3rd row of the new question as you did in the first two rows.
Secondly, you needed to indicate you seek the second "/" for the second part of the formula.

Mr excel questions 67.xlsm
	A	B	C	D	E
1
2	Original Question	Spill	Sum
3	(T)*(0.25)*(d/0.025)	10	35	10	=0.25/0.025
4	(T)*(0.5)*(d/0.1)	5		5	=0.5/0.1
5	(T)*(0.4)*(d/0.02)	20		20	=0.4/0.02
6
7
8	Subsequent Question
9	(T)*(0.25)*(d/0.025) + (T)*(0.25)*(d/0.025)	20	55	20	=0.25/0.025 + 0.25/0.025
10	(T)*(0.5)*(d/0.1) + (T)*(0.5)*(d/0.1)	10		10	=0.5/0.1 + 0.5/0.1
11	(T)*(0.4)*(d/0.02) + (T)*(0.5)*(d/0.1)	25		25	=0.4/0.02 + 0.5/0.1
Sheet1 (2)

Cell Formulas
Range	Formula
B3:B5	B3	=TEXTAFTER(TEXTBEFORE(A9:A11,")",2),"(",2)/TEXTAFTER(TEXTBEFORE(A9:A11,")",3),"/")
C3	C3	=SUM(TEXTAFTER(TEXTBEFORE(A9:A11,")",2),"(",2)/TEXTAFTER(TEXTBEFORE(A9:A11,")",3),"/"))
E3:E5,E9:E11	E3	=FORMULATEXT(D3:D5)
D3	D3	=0.25/0.025
D4	D4	=0.5/0.1
D5	D5	=0.4/0.02
B9:B11	B9	=TEXTAFTER(TEXTBEFORE(A9:A11,")",2),"(",2)/TEXTAFTER(TEXTBEFORE(A9:A11,")",3),"/") +TEXTAFTER(TEXTBEFORE(A9:A11,")",5),"(",5)/TEXTAFTER(TEXTBEFORE(A9:A11,")",6),"/",2)
C9	C9	=SUM(TEXTAFTER(TEXTBEFORE(A9:A11,")",2),"(",2)/TEXTAFTER(TEXTBEFORE(A9:A11,")",3),"/") +TEXTAFTER(TEXTBEFORE(A9:A11,")",5),"(",5)/TEXTAFTER(TEXTBEFORE(A9:A11,")",6),"/",2))
D9	D9	=0.25/0.025 + 0.25/0.025
D10	D10	=0.5/0.1 + 0.5/0.1
D11	D11	=0.4/0.02 + 0.5/0.1
Dynamic array formulas.

 

[Formula11]

Thanks again awoohaw, it was indicating for the second "/" which was the issue, now resolved.
Cheers.