Try:

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

HTH

"ron" wrote:

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