If you are trying to match a literal question mark (which is a wildcard
for any single character) you need to prepend a tilde (~) to it.

=COUNTIF(E7:E8,"ALLSTATE INSURANCE CO.VAN~?~?")

Otherwise, without the tildes,
=COUNTIF(E7:E8,"ALLSTATE INSURANCE CO.VAN??")
will match on ALLSTATE INSURANCE CO.VAN followed by any 2 characters.


Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=506388