It will include them, but it is up to the OP to decide whether that is
unwanted or not.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AntnyMI" wrote in message
ups.com...
Wouldn't this also included unwanted results such as "abOUT" and "OUTer
space"?

Bob Phillips wrote:
That should work, but it won't catch say 'get out of here', for that you
need

=COUNTIF(B6:E42,"*out*")

and it won't count say 'the ins and outs is not out' twice, for that you
need

=SUMPRODUCT(LEN(B6:E42)-LEN(SUBSTITUTE(B6:E42,"out","")))/3

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"japc90" wrote in message
ups.com...
I am attempting to write a formula that will count cells containing
the
word "out" and ignore all others, even if they contain text. The
formula I have so far is, =COUNTIF(B6:E42,"*out").
It does not appear to be working. Can anyone offer any advise? Thank
you