finding text string

[dug_41]

You guys are the best. I need to find the number of text values in a range of cells that contain a certain text string. To be specific, some of the text strings may contain the string "32" with no quotes, as in pos32.exe, and I need a count of those. Many thanks...

 

[jindon]

hi

=Countif(YrRnage,"*32*")

should do,
but it counts 132, 324 etc as well.

rgds,
jindon

 

[tactps]

You could include a column with this formula and then copy it down and add them:

=IF(ISERROR(SEARCH("32",A18)),0,1)

You can also use "find" instead of "search" if you need it case sensitive.

 

[Scott R]

Or this:
=SUMPRODUCT(--ISNUMBER(FIND("32",A1:A10)))