Multiple evaluations with an "OR".

[Guest]

What formula can I use to sum numbers in column f, if a="w", b="U" or "i" and
c="s". The sum shoud be 10?

a b c d e f
q a b w 10 1
w u s j 10 3
w s i s 10 5
w i s l 10 7
t a b z 10 13

 

[Guest]

Try:

=SUMPRODUCT(($A$2:$A$6="w")*($B$2:$B$6={"u","i"})*($C$2:$C$6="s")*($F$2:$F$6))

HTH

 

[Guest]

=IF(AND(OR(A1="w",B1="U",B1="i"),C1="s"),sum(F1:F5),"")

Dave