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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Inter" wrote in message
...
Hi,
I've got the sumproduct formula to work (thanks to you guys and girls) but
now what i want to do is sum cells according to 2 criteria ... but i want
both of those criteria to be this OR that OR something else.

To put it another way, i want to sum the number of downloads (in column A)
but only if column B contains either "France" OR "Italy" and column C
contains either "Brand A" OR "Brand B"

Many thanks
Stuart