View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default 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