title: Excel formula SUMIFS use cell value in array range
body: <p>I am using a <code>SUMIFS</code> formula in an excel document, and one part of the formula is an array to check if one value meets a number of criteria. However the data in the array is typed out manually, eg <code>{"Nike", "Amazon"}</code>, however I would like to use a cell value instead of the exact string, i.e. <code>{$K$3, $K$4}</code> but excel does not allow that.</p>
  
  <p>The formula I am using at the moment is as follows:</p>
  
  <pre><code>=SUM(SUMIFS(INDIRECT(C$2&amp;"[Allocation per Account]"),INDIRECT(C$2&amp;"[Team]"),$J$3,INDIRECT(C$2&amp;"[Role]"),$B3,INDIRECT(C$2&amp;"[Account]"),{"Nike","Thirdbridge","Amazon","EIB","Smith &amp; Nephew","ARUP"}))
  </code></pre>
  
  <p>Where by the match of the table range <code>[Account]</code> is set by typing out each value separately.</p>
  
  <p>I have even tried using <code>INDIRECT</code> to print the strings, <code>{INDIRECT($K$3), INDIRECT($K$4)}</code> alas to no avail.</p>
  
  <p>Is there a way to change these values to cell references?</p>