title: Sumif with multiple ranges
body: <p>I tried both, union with braces {} and Flatten to combine 2 simple ranges as the first input in a SUMIF formula. Neither did work. Summing 2 SUMIF formula works of course but that's not really a solution but a short-term workaround.</p>
  <ol>
  <li><p>Try, doesn't work: =SUMIF({B3:B5;E3:E5},&quot;yes&quot;,{A3:A5;D3:D5})</p>
  </li>
  <li><p>Try, doesn't work: =SUMIF(FLATTEN(B3:B5,E3:E5),&quot;yes&quot;,FLATTEN(A3:A5,D3:D5))</p>
  </li>
  <li><p>Try, works crappily: =SUMIF(B3:B5,&quot;yes&quot;,A3:A5)+SUMIF(E3:E5,&quot;yes&quot;,D3:D5)</p>
  </li>
  </ol>
  <p>I prepared this sheet if that helps.
  <a href="https://docs.google.com/spreadsheets/d/1rdt74GNKPtVpnIpMVNCDZ8hWTqZA1P9dq7ZX7Z6-5SU/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1rdt74GNKPtVpnIpMVNCDZ8hWTqZA1P9dq7ZX7Z6-5SU/edit#gid=0</a></p>
  <p>Hoping to learn from you! Kind regards</p>
  <p>Thanks for the insightful answers :)</p>