copy sells down

[Gusher]

Hi

I have a formula :

=sum (E106: E108)

i wish to copy this function to the cell below and add three rows i.e the formula should no read:

= sum (E109 : E 111)

i.e just as if i copied it dowm three rows.

Any ideas , I have many cells to copy down.

Thansk

Mark

 

[sheetspread]

=sum(offset($e$106:$e$108,(row(a1)*3)-3,0))