sequential sums

Posted by J.Glasgow on January 08, 2001 11:12 AM

I want to take the sum of every four cells (i.e. I2-I5, then I6-I9) I want put the formula in one cell and auto fill or drag to fill the rest. Please include full complete excel formulas.

Posted by Mark w. on January 08, 2001 11:16 AM

Enter =IF(MOD(ROW(I2)-ROW($I$2)+1,4),"",SUM(OFFSET(I2,,,-4)))
into J2 and copy down.