Count Numbers in Cells That Also Contain Text

[DAHAWOR1953]

As an example, ="(&E3&") Actual Total For Burns"

             ="(&E4&") Actual Total For Slips"

So the first example would return (5) Actual Total For Burns

The second example would return (7) Actual Total For Slips For Slips

Then at the bottom of the column I want to sum those numbers in the brackets.

Can it be done. Regards Antony

[#2]

@DAHAWOR1953 

Let's say the formulas are in rows 2 to 50.

The formula to sum the numbers is simply

=SUM(E2:E50)

[#3]

@DAHAWOR1953 

Sorry perhaps I haven't explained it clearly.

The cell contains (5) Actual Total for Burns

So, a simple SUM doesn't count the numbers in the brackets. Thats what I am after a formula that adds the numbers in the brackets. So the column consists of numbers in the brackets followed by text.

Regards Antony

[#4]

please share some data and expected result。

[#5 · Accepted solution]

a2=(5) Actual Total for Burns
a3=(7) Actual Total

if extract number then conduct.sum,maybe

=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~\d+~" & A2)+WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~\d+~" & A3)

[#6]

@DAHAWOR1953 

Please try the formula that I proposed. It does not try to add the cells that contain a text, but the cells with the original numbers.