title: I want to sum every 7 rows in a worksheet and put the sum in different column & rows
body: <p>I have never really used Excel before but this seems like it should be possible.</p>
  
  <p>I have an ongoing document where I will be adding values every day, but what I want it to do for every 7 rows I want it to sum those values and add the sum of the 7 rows to a different column/row, e.g.,</p>
  
  <p>Row B7:B14  Sum in D12<br>
  Row B15:B22 Sum in D13</p>
  
  <p>And then when I start adding data into B23 I want it to add the sum to D14.</p>