Parsnip said:enter this:
=SUM(IF(MOD(ROW(A1:A100),4)=0,A1:A100))
and confirm with Ctrl+Shift+Enter (it's an array formula).
Best regards
Richard
vane0326 said:A non-array formula.
Put this formula in cell A4 and copy it down.
=IF(ROUND((CELL("row",A4)/4),0)=(CELL("row",A4)/4),SUM(A1:OFFSET(A4,0,0)),"")
...
ADVERTISEMENT
Aladin Akyurek said:vane0326 said:A non-array formula.
Put this formula in cell A4 and copy it down.
=IF(ROUND((CELL("row",A4)/4),0)=(CELL("row",A4)/4),SUM(A1:OFFSET(A4,0,0)),"")
...
Is that not too expensive and non-robust?
just_jon said:=IF(MOD(ROW(),4)=0,SUM(INDEX(A:A,ROW()-3):A1),"")
In A1 copied down.