Hi Ashish, of course SUM with CTRL+SHIFT+ENTER is an alternative but you
don't really need the IF in this case

=SUM((B4:B6="Yes")*(C4:C6="Smith"))

would suffice


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=516581