try this if your dates ARE dates
=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(month(Odyssey!$AI$2:$AI$999)=8))


--
Don Guillett
SalesAid Software

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:6476766e5d591@uwe...
Basically all I want to do is count the number of dates that ="Y" in
columns
AH, for the month of August 06. The date field is in column AI.


=SUMPRODUCT(--(Odyssey!$E$2:$E$999=B7),--(Odyssey!$AH$2:$AH$999="Y"),--
(Odyssey!$AI$2:$AI$999=8/1/6),--(Odyssey!$AI$2:$AI$999<=8/31/6))

Thanks

Sharon

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1