{=SUM(IF((C1:C100="yes"),IF(D1:D100="yes",1,0)))}

You would obviously substitute the C1:C100 and D1:D100 with the range
you need.

This is not case sensative


--
nevi
------------------------------------------------------------------------
nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
View this thread: http://www.excelforum.com/showthread...hreadid=552861