title: Using Google Sheets INDIRECT function to find the top and bottom rows
body: <p>I've been working on a function using <code>SUM INDIRECT</code> in Google Sheets, as I want the <code>SUM</code> to include newly added rows.</p>
  
  <p>The function I have so far is:</p>
  
  <p><code>=SUM(INDIRECT("F5:F"&amp;ROW()-1))</code></p>
  
  <p>I have this function in multiple places throughout my spreadsheet, always tracking the F column. I basically separated my sheet into sections. </p>
  
  <p>My issue is that I need to be able to add or remove rows from anywhere in the sheet, but if I do that if throws off the range specified in my formulas.</p>
  
  <p>What I'd like to do is keep the same functionality, but find a way to tell the function where to start that isn't just giving it a row number.</p>
  
  <p>Any ideas on how I can go about this?</p>