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) Act...
- 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)
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。
