Sum of Different Ranges Keeping Results In Sequential Columns

  • Thread starter Thread starter CONCLA2
  • Start date Start date
C

CONCLA2

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!
 
Non-volatile approach:

=SUM(INDEX($1:$1,4*COLUMNS($A:A)-3):INDEX($1:$1,COLUMNS($A:A)*4))

..And copy across as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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!
 
Back
Top