\n\1\2\n\1
=if(isnumber(search("blah",B2))=TRUE,1,0)
where blah is the substring (what you're searching for), B2 is the string (what your searching in) and 1 represents that it's present and 0 means it isn't.
=sum(A1:C1)
This just sums the cells from A1 to C1