MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sum blocks of 7 rows

Posted by Steve on November 29, 2000 4:15 AM

Is it possible to sum column data in blocks of 7 within excel and have the results returned in an adjacent column? Thanks in advance



Posted by Celia on November 29, 2000 5:29 AM

There is probably a better way, but the following should work.

Assuming your data starts in cell A1, put the following formula in cell B7 and fill down :-

If your data does not start in row 1, the formula and its location need to be adjusted. For example, if it starts in A3, put the following formula in cell B9 :-


Posted by Aladin Akyurek on November 29, 2000 6:41 AM

& apply the procedure used in NOBLANKS.XLS in column C. See