COUNTIF for single word in text

[jewelybrook]

How can i COUNTIF for the word "travel" in a cell which reads, "travel status
thru 6-1-07" or the like?
thanks!

 

[T. Valko]

There are a few ways to do this. Here is the most generic way for a range of
cells:

=COUNTIF(A1:A10,"*travel*")

Biff

 

[Teethless mama]

=COUNTIF(A:A,"*travel*")

 

[jewelybrook]

thank ya'll!

There are a few ways to do this. Here is the most generic way for a range of
cells:

=COUNTIF(A1:A10,"*travel*")

Biff