Your formula returns #VALUE! error
=SUM(IF(FIND("Excel",A1:A100,1),1,0))

Try like this:

=SUM(IF(ISNUMBER(SEARCH("Excel",A1:A100)),1))
ctrl+shift+enter, not just enter

or
=COUNTIF(A:A,"*Excel*")


"Jarek Kujawa" wrote:

=SUM(IF(FIND("Excel",A1:A100,1),1,0))

array-enter it = CTRL+SHIFT+ENTER