Will the dates all be within the same year?

See if this works:

=SUMPRODUCT(--(MONTH(B2:B20)=6),--(ISNA(MATCH(C2:C20,{"X","Y"},0))),--(D2:D20<"Z"),A2:A20)

--
Biff
Microsoft Excel MVP


"freebee" wrote in message
...
Hi, I tried it and it returns 0. My date is entered as 2009-6-1, 2009-6-5,
etc.
Could that be the problem?
Thanks.

"Max" wrote:

Something like this, in say E2:
=SUMPRODUCT((TEXT(B2:B5,"mmmyy")="Jun09")*(ISERROR (MATCH(C2:C5,{"X";"Y"},0)))*(D2:D5<"Z"),A2:A5)
Adapt the ranges to suit

Celebrate your success, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"freebee" wrote:
Hi, I need to sum the following:
Sum qty in Col. A if Col.B shows June dates, but exclues if Col.C=X and
Y,
and exclude if Col.D=Z
I'm using Excel 2003
Can someone help? Thank you