title: setting a dynamic cell reference in excel
body: <p>I have a sheet setup that calculates totals. Easy enough if the data is already there but not if adding new data. So what I would like to be able to do is to not specify a specific end cell for the sum formula but let it update as more columns are added. </p>
  
  <p>How can I do this with <code>=SUM(m4:m?)</code></p>