title: Getting indirect function to change range when dragging across cells
body: <p>Having trouble getting the <code>AC2:AC150</code> to change to <code>AD2:AD150</code> when dragging the formula across cells. There are some slightly similar solutions on the board for this, but I'm having trouble implementing them. Any and all help is appreciated.  </p>
  
  <pre><code>=SUMIF(INDIRECT("'"&amp;$A$3&amp;"'!$a$2:$A$150"),$C18,INDIRECT("'"&amp;$A$3&amp;"'!Ac2:Ac150"))
  </code></pre>