SOLVED

# Count Numbers in Cells That Also Contain Text

Copper Contributor

# Count Numbers in Cells That Also Contain Text

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

5 Replies

# Re: Count Numbers in Cells That Also Contain Text

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

The formula to sum the numbers is simply

=SUM(E2:E50)

# Re: Count Numbers in Cells That Also Contain Text

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

# Re: Count Numbers in Cells That Also Contain Text

please share some data and expected result。
best response confirmed by DAHAWOR1953 (Copper Contributor)
Solution

# Re: Count Numbers in Cells That Also Contain Text

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)

# Re: Count Numbers in Cells That Also Contain Text

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.