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.