SUMPRODUCT WITH A VARIABLE CRITERIA?

[Guest]

HI, I WOULD DO SOMETHING LIKE THIS:

=SUMPRODUCT(--(A2:A500="x"),--(B2:B500=D1),C2:C500)

WHERE (CELL)D1 IS VARIABLE THAT I INTRODUCE

THANKS IN ADVANCE

 

[Carim]

Cif,

See all answers to your previous post ...

If I may repeat myself, what is the precise problem you are facing ?

Carim

 

[Bob Phillips]

You said earlier that it worked, but you need use a separator of ; not
comma.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)