Because it is not testing for =, there is nothing to replace with <. The
key is that it does its biz by testing the MATCH for a number
(ISNUMBER(MATCH(...). So you need to modify that, I would do it by testing
not a number

=SUMPRODUCT(--(NOT(ISNUMBER(MATCH(C1:C10,{"Brand A","Brand B"},0)))),
--(NOT(ISNUMBER(MATCH(B1:B10,{"France","Italy"},0)
))),A1:A10)


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Inter" wrote in message
...
Ok, final question (more out of interest than anything else) ... how would
i
write a formula that would give me the sum of cells in column A that do
not
have either "France" or "Italy" in column B and do not have either "Brand
A"
or "Brand B" in column C?

I'd presume it's a hack of Bob's formula -
=SUMPRODUCT(--(ISNUMBER(MATCH(C1:C10,{"Brand A","Brand
B"},0))),--(ISNUMBER(MATCH(B1:B10,{"France","Italy"},0))),A1: A10) - but i
can't see where you'd put the < that works for a single specific
criteria.

Cheers!
Stuart