Adding a additional column in to a sum range

  • Thread starter Thread starter Kevin Lane
  • Start date Start date
K

Kevin Lane

Hi

I am picking up budget figures from a spreadsheet. I would like to be able
to transfer cumulative figures to the comparative sheet in the following
way. I want to add a specific number of columns together (starting with
column 'C') depending on either an inputed figure (1 - 12) or a For next
loop.

Is there an elegant way of doing this?

Thanks

Kevin
 
Consider keeping 12 sums. Name define the first column sum cell as
ColTotal1. Presuming the choice is in cell A1,

=OFFSET(ColTotal1,0,A1-1)
 
I should have added ... for the sums, again assuming there is an equal
number of rows that can be summed in each column, and also assuming
ColTotal1 is in cell E50:

E50 = sum($e1:e49)

Then you can copy to F50 and as far to the right as you want.
 
Back
Top