Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a additional column in to a sum range
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a additional column in to a sum range
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a additional column in to a sum range
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically adding additional rows | Excel Discussion (Misc queries) | |||
Adding additional worksheets to an existing template | Excel Discussion (Misc queries) | |||
Please help with Sumproduct, adding additional criteria | Excel Worksheet Functions | |||
Adding additional string vs. look up table | Excel Worksheet Functions | |||
Adding additional data to a pivot chart | Charts and Charting in Excel |