Multiple evaluations with an "OR".
 

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

Multiple evaluations with an "OR".
 

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

Multiple evaluations with an "OR".
 

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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