Using Coontif function with a partial text string

[moxiegirl]

Hello, I'm hoping I might get some help with a question I have. I'd probably be described as a low end intermediate user. Right now I'm trying to use the countif function with a search criteria that will look for certain words in a text string. If you look at the attached, I'd want row b3 counted based on the words triple up. The rest of that text string may not be the same in the next "triple up" line, so I need excel return results just on the words triple up. Can that be done and if so what would the syntax be.

Thanks for any help you can offer

Cris

[daffodil11]

Give this a shot:

=COUNTIF(B2:B19,"*Triple Up*")

The * is called a wildcard, and it means 'any number of characters' which I have preceding and proceeding.

[Richard Buttrey]

The simplest way is probably a helper column.
e.g. in L2 copied down

Please Login or Register  to view this content.

Then just sum column L.

[moxiegirl]

Hi, Thanks a bunch it seems to have worked. I really appreciate your help.

Cris