title: How to keep excel formula consistent with inserting new columns
body: <p>In my sheet, my top row is a bunch of dates and I have columns separating the weeks.</p>
  
  <pre><code>| 1.1 | 1.5 | 1.12 | 1.29 |JANUARY TOTAL| 2.3 | 2.15 | FEBRUARY TOTAL|
  ----------------------------------------------------------------------
  </code></pre>
  
  <p>Below each date is the number of hours worked on a project, and in each "MONTH TOTAL" column is a sum of the time worked on each project per month. </p>
  
  <p>When I created this spreadsheet, I put in a filler of 2 blank spaces, but since I can't predict when I'll be working on each project, I have to rely on inserting new columns if I decide to work on something on a day that isn't preset into the sheet. </p>
  
  <p>The problem is that my formulas don't extend all the way to the MONTH TOTAL columns when I insert new columns. For instance, when I create my spreadsheet, my formula for one of the totals in the MONTH TOTAL column would be "=SUM(B2:C2)" but when I insert two more dates I need the formula to be "=SUM(B2:E2)". </p>
  
  <p>Is there a way to encapsulate inserted cells into a formula so that it sums between a bound of two columns and any new inserted cells? </p>