Combination of different cells

[dipkchopra]

Needed a help on an excel scenario



I have a column of say 3 rows containing numbers, Say A, B, C


I need to generate a formula / code to give me sum of all possible number combinations.i.e.

• A + B
• A + C
• B + C
• A + B + C

My real life scenario has more than 3 rows (actually about 15 rows)

 

[PCL]

Can you show a real example with numbers , showing the results yoiu expect and you want it

 

[dipkchopra]

With the given data set:
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]Value 1[/TD]
[TD="class: xl63, width: 64, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl63"]Value 2[/TD]
[TD="class: xl63, align: right"]10[/TD]
[/TR]
[TR]
[TD="class: xl63"]Value 3[/TD]
[TD="class: xl63, align: right"]15
[/TD]
[/TR]
</tbody>[/TABLE]



I am trying to achieve:

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Result 1[/TD]
[TD="class: xl65, width: 64, align: right"]15[/TD]
[TD="class: xl65, width: 64"] [/TD]
[TD="class: xl65, width: 64"]=5+10[/TD]
[/TR]
[TR]
[TD="class: xl65"]Result 2[/TD]
[TD="class: xl65, align: right"]20[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]=5+15[/TD]
[/TR]
[TR]
[TD="class: xl65"]Result 3[/TD]
[TD="class: xl65, align: right"]25[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]=10+15[/TD]
[/TR]
[TR]
[TD="class: xl65"]Result 4[/TD]
[TD="class: xl65, align: right"]30[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]=5+10+15[/TD]
[/TR]
</tbody>[/TABLE]

Needed a help on an excel scenario



I have a column of say 3 rows containing numbers, Say A, B, C


I need to generate a formula / code to give me sum of all possible number combinations.i.e.

• A + B
• A + C
• B + C
• A + B + C

My real life scenario has more than 3 rows (actually about 15 rows)

 

[PCL]

Because you already know what are the possible combinaisons and formulas why you don't put the formulas in a cell
e.g.
I have a column of say 3 rows containing numbers, Say A, B, C => Col A
B1 = A1 + A2
B2 = A1 + A3
B3 = A2 + A3
B4 = A1 + A2 + A3

 

[dipkchopra]

Yes that is easy for a 3 row combination. But for a 15 row data to do it manually is very tiresome.
Need an automated solution. Some days the no of rows also fluctuate between 12 to 20

Because you already know what are the possible combinaisons and formulas why you don't put the formulas in a cell
e.g.
I have a column of say 3 rows containing numbers, Say A, B, C => Col A
B1 = A1 + A2
B2 = A1 + A3
B3 = A2 + A3
B4 = A1 + A2 + A3