title: SUMIF with OR criteria
body: <p>How to use <code>SUMIF</code> formula in Excel cell that must sum over a given range and instead of finding for a single value, it should find multiple values?</p>
  
  <p>For finding a single value, I use:</p>
  
  <pre><code>=SUMIF(A4:A100;"1";B4:B100)
  </code></pre>
  
  <p>Now I need to sum over if the column <code>A</code> holds <code>1</code> or <code>2</code>, like:</p>
  
  <pre><code>=SUMIF(A4:A100;"1" OR "2";B4:B100)
  </code></pre>
  
  <p>The cell <code>A1</code> will hold the criteria as a text, here it would be <code>1;2</code>.</p>
  
  <p>It should return same as</p>
  
  <pre><code>=SUMIF(A4:A100;"1";B4:B100) + SUMIF(A4:A100;"2";B4:B100)
  </code></pre>
  
  <p>but I need a formula that can take any number of criteria (1,2,3,... or more).</p>
  
  <p>What's the syntax? I'm not able to use VBA here.</p>