title: SumIfs conditional array criteria
body: <p>I have a simple formula like: <code>IFERROR(SUM(SUMIFS(TBL1[SUMCOLUMN],TBL1[ACTIVITY],{"0001","0002","0003"})),0)</code> and it works.</p>
  
  <p>But I want the <code>{"0001","0002","0003"}</code> part to be different based on the value of a column so I change the formula to:  <br></p>
  
  <pre><code>IFERROR(SUM(SUMIFS(TBL1[SUMCOLUMN],TBL1[ACTIVITY],IF([@TYPE]="EHT",{"0001","0002","0005"},IF([@TYPE]="CT",{"0003","0004","0007"},"0010")))),0)
  </code></pre>
  
  <p>And it gives me values only based on the first array value.
  Example:</p>
  
  <pre><code>IF([@TYPE]="EHT",{"0001","0002","0005"} //Gives me sum of only where "0001" and ignores "0002","0005" 
  IF([@TYPE]="CT",{"0003","0004","0007"} //Gives me sum of only where "0003" and ignores "0004","0007" 
  </code></pre>
  
  <p>I thought excel is converting the critera into text so I have played around with different methods like using char(34), different number of quotes, putting values in different cells and referencing but no help.
  Any idea what I am missing?</p>
  
  <p>Sample tables:
  TBL1:</p>
  
  <pre>
  SUMCOLUMN   ACTIVITY
  5           0001
  20          0002
  50          0003
  ...
  
  TBL2:
  TYPE        TOTAL
  EHT         SUMIFS GOES HERE
  CT          SUMIFS GOES HERE
  OTHER       SUMIFS GOES HERE
  </pre>