Selectable Column SUM

[RobN via OfficeKB.com]

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.

 

[Joel]

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]

This should work fine, thanks Joel!

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.