Thread: Can't sum numbers from result of If statement

I'm using the following formula to check and see if a cell contains certain text:

=IF(ISNUMBER(SEARCH("100m Pred",D4)),"1"," 0")

If it the text is there it puts a 1, if not, a 0. However, when I try to sum a column of these ones and zeros, the answer is always 0 because the numbers are not being recognized. I tried formatting all the cells as numbers, but that did not solve the problem.


EDIT: Turns out the quotation marks around the numbers were the problem. Whoops.

Yes. If you put "" around number you will get text and not number.

If, from some other result you get number as text you can also convert it back to number by for example adding 0 or multiplying by 1.... (="1"+0)

However, this will give you error if result is some other text as ="a"+0