title: Excel formula to Sum every 5 rows
body: <p>i'm struggling with an excel formula:</p>
  
  <p><strong>NEED:</strong> I need a formula to sum every 5 rows <em>AND</em> place the value on the respective row. (see table below) </p>
  
  <p>Here's what i have so far but it isn't quite there:</p>
  
  <pre><code>=SUM(OFFSET($A$2,(ROW()-ROW($B$2))*5,,5,))
  
      | A   |  B | C
  -----------------------
  1   | 5   | 37 | 37  
  2   | 10  | 24 | 37
  3   | 7   | 17 | 37
  4   | 7   | 0  | 37
  5   | 8   | 0  | 37  
  6   | 1   | 0  | 24
  7   | 3   | 0  | 24  
  8   | 5   | 0  | 24  
  9   | 5   | 0  | 24
  10  | 10  | 0  | 24
  11  | 5   | 0  | 17
  12  | 1   | 0  | 17
  13  | 8   | 0  | 17
  14  | 2   | 0  | 17
  15  | 1   | 0  | 17
  </code></pre>
  
  <p>COLUMN "A" = VALUES </p>
  
  <p>COLUMN "B" = CURRENT OUTPUT (w/Formula Above)</p>
  
  <p><strong>COLUMN "C" = DESIRED OUTPUT</strong></p>
  
  <p>Thanks for your assistance.</p>