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.
Bookmarks