| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to sum columns
A B C D E
1 1 2 3 4 5 2 361 311 296 247 303 3 596 562 234 979 536 4 5 Say cell B5 contents 4. What is the formula to sum columns with no of columns based on cell B5 (column A2 to D2)? Thanks js |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to sum columns
One way
In C5: =SUM(OFFSET(A2,,,,B5)) where B5 contains: 4 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "js" wrote: A B C D E 1 1 2 3 4 5 2 361 311 296 247 303 3 596 562 234 979 536 4 5 Say cell B5 contents 4. What is the formula to sum columns with no of columns based on cell B5 (column A2 to D2)? Thanks js |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Linear Mode
