sumproduct with "OR" conditions

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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"))
 
If you have only three conditons then simply add up three SUMPRODUCTS, one
for each condition..
 
Following worked in Excel 2007
=SUMPRODUCT(--(AC11:AC1152={"Condition1","Condition2","Condition3"}))
 
Back
Top