title: VBA - SumIfs with Or
body: <p>I have researched this issue everywhere, and I can't find an answer to my particular situation.</p>
  
  <p>Here's my SumIfs statement.</p>
  
  <pre><code>B_white = Application.SumIfs(Range("G84:G" &amp; LastRow), Range("G84:G" &amp; LastRow), "1", Range("K84:K" &amp; LastRow), "B*", Range("L84:L" &amp; LastRow), "2 (test)")
  </code></pre>
  
  <p>For the final criterion, it needs to look for "2 (test)" OR just "2" but I can't use "2*" because there will be cells with "22" and "28" in them.</p>
  
  <p>How can I alter this SumIfs statement so that it looks for "2 (test)" or "2"?</p>