title: How to use OR Operator with SumIfs()
body: <p>How do I use SumIfs to sum if 1 out of 3 criteria (=OR) matches?</p>
  
  <p>How can I use OR for the criteria? Here is the pseudocode.</p>
  
  <pre><code>Sub SumDemo()
  
      Dim Sum
  
      Sum = Application.WorksheetFunction.SumIfs([REVENUE], [UNIT], "=avengers", [region], "=north OR =south OR = west")
  
      MsgBox Sum
  
  End Sub
  </code></pre>