=SUMPRODUCT(--(B1:B20=--"2005-10-18"),--ISNUMBER(MATCH(C1:C20,{"ABC","BCD"},
0)),D1:D20)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John Moore" wrote in message
...
Hi,
I have a SUMPRODUCT with multiple criteria and wish to add another
condition using OR ,,,,,, e.g.
A B C D
Pens 18/10/2005 ABC 25
Pens 18/10/2005 BCD 10
Pens 18/10/2005 DEF 15

What I want to achieve is to sum the product in col A that matches the
date
in col B
and has a location ( col C ) of either ABC OR BCD and sum col D.