title: How to apply multiple conditions from one cell for SUMIF | GoogleSheets
body: <p>Do you have an idea for a function that would sum <strong>the amounts</strong> from <strong>table 2</strong> based on <code>Unique_nr</code> from Table 1?</p>
  <p>I tried to do it this way:</p>
  <pre><code>=SUM(ARRAYFORMULA(SUMIF(E3:E9,{SPLIT(A3,&quot;,&quot;)},F3:F9))) &lt;---doesn't work
  
  =SUM(ARRAYFORMULA(SUMIF(E3:E9,{&quot;8-1&quot;,&quot;9-1&quot;},F3:F9))) &lt;----It works
  </code></pre>
  <p>Theoretically the <strong>SPLIT()</strong> function gives the same result as I type manually, but unfortunately it doesn't work.</p>
  <p>I would like to do this with one function for the entire range of data</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1JGvFIZIE6c_D0A2Z4xCWf7pxqVft4Zsb6S-45_d9LY4/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1JGvFIZIE6c_D0A2Z4xCWf7pxqVft4Zsb6S-45_d9LY4/edit?usp=sharing</a>
  <a href="https://i.stack.imgur.com/GBekm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GBekm.png" alt="enter image description here" /></a></p>