=sumproduct(('Student
Listing'!$A$2:$A$300=datevalue("10/1/04"))*('Student
Listing'!$A$2:$A$300<=datevalue("10/31/04"))*('Student
Listing'!$F$2:$F$300="Yes")*1)

count of all occurances of yes between 10/1 and 10/31 inclusive

assumes the dates in column A are dates and not text


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320505