this should work then as it does on 2003


=SUMPRODUCT(($E$6:$E$500=A4)*($T$6:$T$500=1))


--
Backdoor Cover
------------------------------------------------------------------------
Backdoor Cover's Profile: http://www.excelforum.com/member.php...o&userid=19842
View this thread: http://www.excelforum.com/showthread...hreadid=376072