The answer should be 1

Just enter some other numbers in C or codes in columns A and B and you'll
see what it does.

--
Greetings from New Zealand
Bill K

"JN" wrote in message
...
Can anyone tell me what I'm doing wrong on this example? The answer is 1

COL A COL B COL C
PF LAN 0
PF PFT 1

=SUMPRODUCT((A1:A2="PF")*(B1:B2={"LAN","PFT"})*(C1 :C2))