yankeefan70
New Member
- Joined
- Jan 27, 2014
- Messages
- 2
Trying to sum a large worksheet but only every 7 rows and want the formula to repeat. Example
A1 to A100 has an # in the cell
Formula I want to repeat in each row in column B
B1 = Sum A1:A7
B2 = Sum A8:A14
etc...
copy and paste only goes to next row B2 now equals A2:A8, etc...
A1 to A100 has an # in the cell
Formula I want to repeat in each row in column B
B1 = Sum A1:A7
B2 = Sum A8:A14
etc...
copy and paste only goes to next row B2 now equals A2:A8, etc...