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