title: How do I reference multiple structured tables in a sumif or sumifs in excel
body: <p>I am wishing to reference multiple structured tables (one on each sheet) to sum up $dollar values by category .</p>
  <p>I did sumifs practice from microsoft, which did not use structured tables. It referenced the worksheets and cells.   (see the excercise) as an image. Here is the formula used: <a href="https://i.stack.imgur.com/TL8J8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TL8J8.png" alt="screen shot of cells" /></a>
  =SUMPRODUCT(SUMIFS(INDIRECT(&quot;'&quot;&amp;F$3:F$7 &amp; &quot;'!&quot;&amp;&quot;D$3:D$7&quot;),INDIRECT(&quot;'&quot;&amp;F$3:F$7&amp;&quot;'!&quot;&amp;&quot;C$3:C$7&quot;),H3))<br />
  This worked fine.</p>
  <p>Then I did the single page, single table formula with the structured table:</p>
  <pre><code>=SUMIFS(tbl_Dir_Inv_6855468[Value],tbl_Dir_Inv_6855468[Category],[@Category])
  </code></pre>
  <p>This worked also.
  Then I thought I would be able to add the other tables using the Indirect Function.
  I made a list of my table names that I want accessed: in address: I11:I16. tbl1  tbl2  etc.
  I tried to work with the practice formula and adapt it: This is what I tried.</p>
  <pre><code>=SUMIFS(INDIRECT(&quot;&amp;I$11:I$16&quot; &amp;&quot;[Value]&quot;INDIRECT(&quot;&amp;I$11:I$16&quot; &amp;&quot;[Category]&quot;,[@Category]))
  </code></pre>
  <p>I also tried  - adding back the single apostrophe
  =SUMIFS(INDIRECT(&quot;'&quot;&amp;I$11:I$16&quot;'&quot; &amp;&quot;[Value]&quot;INDIRECT(&quot;'&quot;&amp;I$11:I$16&quot;'&quot; &amp;&quot;[Category]&quot;,[@Category]))
  Neither of these worked.</p>
  <p>I am not sure if it is a syntax error because of the apostrophes wrong or is it that I can't just put a table name in using the Indirect function. I am totally new to Structured Tables and not very skilled at excel. I hope that I have asked this question properly so as not to waste peoples time here.
  Sorry, I also couldn't figure out how to tag the code as code here. I thought that it was just 4 enters before the code.
  Thank you For your Help.</p>