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)
Let's say the formulas are in rows 2 to 50.
The formula to sum the numbers is simply
=SUM(E2:E50)