sure

--
Don Guillett
SalesAid Software

"s2m via OfficeKB.com" <u23063@uwe wrote in message
news:64769a3405b31@uwe...
That Works GREAT!

Can I keep building on a SUMPRODUCT? Adding more conditions? Like AZ= N,
AM= Y and so on?

Don Guillett wrote:
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))

Basically all I want to do is count the number of dates that ="Y" in
columns
[quoted text clipped - 6 lines]

Sharon

--
Message posted via http://www.officekb.com