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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Inter" wrote in message
...
Thanks for both of these ... very helpful.

Follow up question though - how about if i want to sum the cells in column
A
that have "France" OR "Italy" in column B but DO NOT have "Brand A" (i.e.
do
have anything apart from "Brand A") in column C?

Cheers
Stuart