Forum Discussion
Solved
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
- 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)
5 Replies
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
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.
- 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) - please share some data and expected result。
Let's say the formulas are in rows 2 to 50.
The formula to sum the numbers is simply
=SUM(E2:E50)
