Excel: Count Values in Cells

I have a list of countries recorded in Cells from A2 to A1000, some cells have 4 or more countries recorded, and I want to Count certain countries I have been using this Formula where I have the country that I am looking for entered into Cell C1 =COUNTIF($A$2:$A$100,"*"&C$1&"*") What it doesn't do is separate those countries with some of the same name like Sudan and South Sudan also North Korea and South Korea Therefore can any on help with the formula

This question generated 33 answers. To proceed to the answers, click here.

This thread is current as of June 08, 2014.

For more resources for Microsoft Excel