title: How can you query and SUM total a Column name, rather than "=SUM(A:A)" in Sheets?
body: <ul>
  <li>I want to create a query that uses SUM to add total all values in a column,
  into a single cell, using a distinct column name.</li>
  </ul>
  <p>Sometimes the Column may move when new inventory is added, causing the reference to fail/not match...</p>
  <p>I want the reference to connect to a distinct column name, not &quot;A:A&quot;</p>
  <p><em>From my research, it seems the answer is along the lines of ADDRESS() and/or MATCH()</em></p>
  <p>But here's the simple <a href="https://i.stack.imgur.com/deknu.png" rel="nofollow noreferrer">Query and Issues</a>, referencing to column &quot;A&quot;:</p>
  <pre><code>=QUERY(Sheet2!A:A, &quot;select sum (A) label sum (A) ''&quot;)
  </code></pre>
  <p>You can also see I set the label to '' so it only returned the value.</p>
  <p>Any help or advice to help pipe the API data into a main sheet would be appreciated.</p>