1)SUMPRODUCT((VALUE(A1:A8)=VALUE("12/6/2004"))*(VALUE(A1:A8)<=VALUE("12/12/2004"))*(B1:B8="Standard"))

2)SUMPRODUCT((VALUE(A1:A8)=VALUE("12/6/2004"))*(VALUE(A1:A8)<=VALUE("12/12/2004"))*(B1:B8="Standard")*(C1:C8="No"))


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277230