I have data in cells 1 €“ 297 in a worksheet that I want totaled in new
workbook like so€¦

Row 1 @sum(A1:A5)
Row 2 @sum(A6:A10)
Row 3 @sum(A11:A15) Etc.

When I enter the formula in the first cell of the new workbook and copy the
data down, it fills in increments of 1 instead of increments of 5

Row 1 @sum(A1:A5)
Row 2 @sum(A2:A6)
Row 3 @sum(A3:A7)