It workes fine for me:.
=SUMPRODUCT((A2:A10=DATE(2005,5,2))*(A2:A10<=DATE (2005,5,6))*(ISNUMBER(B2:B10)))
--- 4
Hope it helped
Ola Sandström
Pictu
http://www.excelforum.com/attachment...tid=3501&stc=1
+-------------------------------------------------------------------+
|Filename: Clipboard01.jpg |
|Download:
http://www.excelforum.com/attachment.php?postid=3501 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=379171