use this formula, where C2 holds the name of the country to count:

=SUMPRODUCT((A2:A100="Y")*(B2:B100=C2))

adjust the ranges as needed to match your data.

HTH

Bruce

NOTE: please don't multi-post


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466775