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

Steve,

(Frustrated)


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


Steve
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(MOD(ROW(),7)=0,SUM(A1:A7),"")

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 :-
=IF(MOD(ROW()-2,7)=0,SUM(A3:A9),"")

Celia

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

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

http://www.cpearson.com/excel.htm

Aladin