SUMPRODUCT WITH A VARIABLE CRITERIA?
 

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

SUMPRODUCT WITH A VARIABLE CRITERIA?
 

Cif,

See all answers to your previous post ...

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

Carim

SUMPRODUCT WITH A VARIABLE CRITERIA?
 

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)

"Cif" wrote in message
...
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