try
=SUMPRODUCT((A1:A2="PF")*(or(B1:B2="LAN",B1:B2="PF T"))*(C1:C2))

"JN" wrote:

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