=SUMPRODUCT(--(A1:A100=\"Y\"),--(B1:B100=\"GERMANY\"))

is your formula and next time, it is not necessary to multipost
whatever problem you have.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=466772