title: Reference nearby cells in Excel
body: <p>I realize this may not be the best place for this, but I need some help with Excel formulas.  I am trying to have one cell reference another in the same row, without declaring the cell by number.  This way, when I sort them the references do not become mixed, often with the bottom of the table having formulas that reference the top.  For example: </p>
  
  <pre><code>=SUMIF(Team_Number_Hub,'Gross Stats'!A3,Autonomous_Assist_Hub)
  </code></pre>
  
  <p>I would like to replace 'Gross Stats'!A3 with something that can reference only the cell 3 columns to the left, instead of that specific cell, which will often change places.  If possible, I would like to do this without additional coding, but if that is necessary I'm up for it.  </p>