count if in excel - can this be done

You might need to leave the dashes on either side of the city abbreviation to avoid counting cells that coincidently have that text.
Example:
(DON-MTL-AdvantageTours-Cab3) contains "van" but doesn't refer to Vancouver.

Originally Posted by Ron Coderre

You might need to leave the dashes on either side of the city abbreviation to avoid counting cells that coincidently have that text.
Example:
(DON-MTL-AdvantageTours-Cab3) contains "van" but doesn't refer to Vancouver.

you logic is sound, ty again!