I don't know what I'm doing wrong, but if I use this formula I get a count of
14 instead of 5, which I what I count when I set the filters. I can't figure
out where the 14 comes from. There is only 5 dates less that today's date in
column AI. I have been working on this darn thing for 2 days and just can't
figure it out.


=SUMPRODUCT(--(Odyssey!$E$2:$E$771=B7),--(Odyssey!$AH$2:$AH$771="Y"),--
(Odyssey!$AI$2:$AI$771<=TODAY()))

If i change the formula to this

=SUMPRODUCT(--(Odyssey!$E$2:$E$771=B7),--(Odyssey!$AH$2:$AH$771="Y"),--(MONTH
(Odyssey!$AI$2:$AI$771)=8))

I get the right count of 5

HELP

Basically all I want to do is count the dates in the PLAN Date column (AI)
that equal to a condition or Y in column (AH)
Compare it to the Actual date(AJ)

I am bald head right now, lol

Thanks for all your help

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