title: INDIRECT for a whole column on another sheet
body: <p>Ive searched around for how to use the indirect command for a whole column (on another sheet) but with limited responses</p>
  
  <p>Ive seen it has to be something like this</p>
  
  <pre><code>=SUMIF(Site!$A:$A,D11,indirect("Site!$F",Row($F))
  </code></pre>
  
  <p>The reason I want to use indirect is because the cells on that sheet are always changing (and columns are being delted / recreated automatically) - But the data I need will always end up in the same cell (But the formula automatically readjusts when you delete a col etc)</p>
  
  <p>Any help would be awesome</p>