View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
 
Posts: 273
Default sumproduct with "OR" conditions

How do I display results if ANY of three conditions are True rather than when
ALL 3 conditions are True?

My formula is =SUMPRODUCT(--(AC11:AC1152="Condition
1"),--(AC11:AC1152="Condition 2"),--(A11:A1152="Condition 3"))