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
|