Thread: Formula counts incorrectly
View Single Post
  #2  
Old 06-14-2005, 05:56 PM
olasa olasa is offline
Forum Guru
  
Join Date: 24 Dec 2004
Location: Sweden
Posts: 1,081
olasa is becoming part of the community
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


Picture:
http://www.excelforum.com/attachment...tid=3501&stc=1
Attached Images
File Type: jpg Clipboard01.jpg (44.0 KB, 28 views)
Reply With Quote