| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selectable Column SUM
I am trying to determine a method which will allow me to sum a specific
number of cells in a row of data based on a cell value (in this case values in col B). An example should be worth a 1000 words: A B C D E F G 1 part1 #cols col1 col2 col3 col4 col5 2 AA 2 1 2 0 1 0 3 BB 1 1 1 0 1 1 4 CC 3 2 2 2 2 2 Desired Output (located in another worksheet) A B C D ..... 1 part1 #cols col1 col2 ..... 2 AA =C2+D2 =D2+E2 =E2+F2 ..... 3 BB =C3 =D3 =E3 ..... 4 CC =C4+D4+E4 =D4+E4+F4 =E4+F4+G4 ..... Any help would be greatly appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200805/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selectable Column SUM
use sum with offset.
C2 - the row of data starting at C2 0 - the x-offset of data from C2 0 - the y-offset of data from Ce 1 - the number of rows to sum which is 1 B2 - the number of columns to add. =SUM(OFFSET(C2,0,0,1,B2)) "RobN via OfficeKB.com" wrote: I am trying to determine a method which will allow me to sum a specific number of cells in a row of data based on a cell value (in this case values in col B). An example should be worth a 1000 words: A B C D E F G 1 part1 #cols col1 col2 col3 col4 col5 2 AA 2 1 2 0 1 0 3 BB 1 1 1 0 1 1 4 CC 3 2 2 2 2 2 Desired Output (located in another worksheet) A B C D ..... 1 part1 #cols col1 col2 ..... 2 AA =C2+D2 =D2+E2 =E2+F2 ..... 3 BB =C3 =D3 =E3 ..... 4 CC =C4+D4+E4 =D4+E4+F4 =E4+F4+G4 ..... Any help would be greatly appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200805/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selectable Column SUM
This should work fine, thanks Joel!
Joel wrote: use sum with offset. C2 - the row of data starting at C2 0 - the x-offset of data from C2 0 - the y-offset of data from Ce 1 - the number of rows to sum which is 1 B2 - the number of columns to add. =SUM(OFFSET(C2,0,0,1,B2)) I am trying to determine a method which will allow me to sum a specific number of cells in a row of data based on a cell value (in this case values [quoted text clipped - 16 lines] Any help would be greatly appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200805/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selectable Criteria | Charts and Charting in Excel | |||
| How do I add N/A to a selectable cell with an arrow? | Excel Worksheet Functions | |||
| How do I make a line non-selectable? | Excel Discussion (Misc queries) | |||
| How do I insert a selectable circle in Excel? | Excel Worksheet Functions | |||
| Help please- user selectable image | Excel Programming | |||
Hybrid Mode
