SUMPRODUCT WITH A VARIABLE CRITERIA?

C

Cif

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
 
C

Carim

Cif,

See all answers to your previous post ...

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

Carim
 
B

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)
 
Top