One Way

=SUMIF(B:B,3,D:D)/COUNTIF(B:B,3)


--
Rowan
------------------------------------------------------------------------
Rowan's Profile: http://www.excelforum.com/member.php...o&userid=26535
View this thread: http://www.excelforum.com/showthread...hreadid=398000