use:
=SUMPRODUCT(--(D1:D100=8),--(E1:E100=25))

Don't use D:D, instead use D1:D100 or any large number

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=392835