title: Repeating Excel Formula every N rows
body: <p>I am trying to add a repeating formula in Excel that will sum a range of values in another column (scores) for each subject to get a Total Score for each subject. </p>
  
  <p>I have added the following formula which seems to total the values correctly:  </p>
  
  <p>SUM(OFFSET($AO$2,(ROW()-424)*424,0,424,1))</p>
  
  <p>You can see it here<br>
  <a href="https://i.stack.imgur.com/8DIjK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8DIjK.png" alt="]: https://i.stack.imgur.com/8DIjK.png"></a></p>
  
  <p>Here is the result I currently have from adapting the formula...</p>
  
  <p><a href="https://i.stack.imgur.com/xB5kT.png" rel="nofollow noreferrer">Image 2</a></p>
  
  <p>Does anyone know how can I get this formula to repeat every 425 rows in this column (AQ)?</p>
  
  <p>Thanks for any tips.</p>