Countif formula for specific text within range

[NoScreenName]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to count the number of times a specific text (e.g. Public Transportation) appears within a range. The cells appear as follows:

Employment; Public Transportation
Public Transportation
Public Transportation; Rural Development

I tried using "Public Transportation" as the criteria, but it doesn't count the cells containing other text beside it.

Appreciate some help.

 

[John McGhie]

COUNTIF performs an "exact match". You need to use the "Find" function to
perform a partial match.

Look up "FIND" in the Excel Help.

You need something like =COUNTIF(Find(....)<>0)

So you count the number of times FIND returns a non-zero result.

Get back to me if you need more information.

Cheers

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to count the number of times a specific text (e.g. Public
Transportation) appears within a range. The cells appear as follows:

Employment; Public Transportation
Public Transportation
Public Transportation; Rural Development

I tried using "Public Transportation" as the criteria, but it doesn't count
the cells containing other text beside it.

Appreciate some help.

--

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]