In A5: =SUM(OFFSET($A$1,0,(COLUMN()-1)*4,1,4))
copy across

"CONCLA2" wrote:

This is what I'm trying to do:

=Sum(A1:D1) with the result being in A5 - Now I want to copy or drag, so I
don't have to keep retyping, the formula in A5 to B5 with results being
=Sum(E1:H1)

This way I can see all the sumed ranges without having to scroll over.

Any suggestions? Thanks!