Multiple evaluations with an "OR".

R

ron

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
 
T

Toppers

Try:

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

HTH
 
Top