Suming Increments of 4

[vgirl76]

I have data for Quarter 1 thru Quarter 4
Q1-4 repeats increments of 4 for 900 lines
I want a formula that when i drag it down will only sum increments of 4

As you can imagine when i do a sum it will do A1:A4 but when i drag down it will sum A2:A5
I want it to do A1:A4 then A5:A9

 

[cornflakegirl]

This will do it:

=SUM(OFFSET($A$1,4*(ROW(A1)-ROW($A$1)),0):OFFSET($A$4,4*(ROW(A1)-ROW($A$1)),0))

But as OFFSET is volatile, there is probably a better way to do it.

 

[Domenic]

Here's another way...

B1, copied down:

=SUM(INDEX($A$1:$A$900,ROWS(B$1:B1)*4-4+1):INDEX($A$1:$A$900,ROWS(B$1:B1)*4))