I believe this formula can help you to get you want. Extend the range to
your needs ...

{=SUM(IF(B2:B1000="Jim",IF(E2:E1000="Assigned",1,0 )))}


--
prague
------------------------------------------------------------------------
prague's Profile: http://www.excelforum.com/member.php...o&userid=30172
View this thread: http://www.excelforum.com/showthread...hreadid=516086