Copy down formula

  • Thread starter Thread starter Techad
  • Start date Start date
T

Techad

I would like to customise the copy down formula to increment by 4 each
time instead of 1. Ex

Row 1 =SUM(A10:A13)
Row 2 + SUM(A14:A17)

etc.

Any ideas?

Many thanks
 
Hi
try the following formula in your first cell:
=SUM(OFFSET($A$10:$A$13,(ROW(1:1)-1)*4,0))
and copy down
 
Back
Top