sumproduct formula (multiple criteria)
Try this solution using a helper column:
Formula in helper column (say G), cell G2:
=AND(OR(B2="France",B2="Italy"),OR(C2="Brand A",C2="Brand B"))
and drag it down as required!
SUMPRODUCT formula:
=SUMPRODUCT(A2:A10,--G2:G10)
Regards,
Stefi
€žInter€ť ezt Ă*rta:
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
|