Grid Sum (it could be all way possible from min to max)

[motilulla]

Hello,

I have a grid constructed with 9 columns & 7 rows using cells B3:J9 random numbers are filled in each rows
I want to pick 1 number from each row and create a list in columns M:S with all possible sums could be made from minimum to maximum

Given example below show min sum could be made 1 & max sum could be made 252

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1												All Possible
2		n1	n2	n3	n4	n5	n6	n7	n8	n9		Sum	C1	C2	C3	C4	C5	C6	C7
3		0	9	2	1	3	8	5	48	19		1	0	1	0	0	0	0	0
4		1	0	4	8	29	11	22	17	2		2
5		4	9	0	11	2	5	3	7	15		3
6		3	4	8	0	6	10	49	2	1		4
7		0	10	3	5	2	24	63	1	11		,,,
8		2	21	0	14	13	16	1	7	5		,,,
9		5	1	0	27	10	14	3	15	22		,,,
10												,,,
11												,,,
12												,,,
13												249
14												250
15												251
16												252	48	29	15	49	63	21	27
17
Hoja3

Cell Formulas
Range	Formula
L3	=SUM(M3:S3)
L16	=SUM(M16:S16)

So my request is it possible could be made all possible list of combinations from min & max sum 1 to 252

Thank you all

Excel 2000
Regards,
Moti

 

[Gerald Higgins]

Hi, your request is pretty vague, what exactly do you want to do ?

Can you post an example of what the results should be ?

 

[motilulla]

Hello, I think you are correct instead saying all possible sums; really I want all possible combination could be made with this 9*7 grid picking 1 number from each row and generating all combinations in the set of 7

May be like this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2		n1	n2	n3	n4	n5	n6	n7	n8	n9		C1	C2	C3	C4	C5	C6	C7
3		0	9	2	1	3	8	5	48	19		0	1	4	3	0	2	5
4		1	0	4	8	29	11	22	17	2		0	0	4	3	0	2	1
5		4	9	0	11	2	5	3	7	15		0	4	4	3	0	2	0
6		3	4	8	0	6	10	49	2	1		0	8	4	3	0	2	27
7		0	10	3	5	2	24	63	1	11		0	29	4	3	0	2	10
8		2	21	0	14	13	16	1	7	5		0	11	4	3	0	2	14
9		5	1	0	27	10	14	3	15	22		0	22	4	3	0	2	3
10												0	17	4	3	0	2	15
11												0	2	4	3	0	2	22
12
13												9	1	4	3	0	2	5
14												9	0	4	3	0	2	1
15												9	4	4	3	0	2	0
16												9	8	4	3	0	2	27
17												9	29	4	3	0	2	10
18												9	11	4	3	0	2	14
19												9	22	4	3	0	2	3
20												9	17	4	3	0	2	15
21												9	2	4	3	0	2	22
22
23												2	1	4	3	0	2	5
24												2	0	4	3	0	2	1
25												2	4	4	3	0	2	0
26												2	8	4	3	0	2	27
27												2	29	4	3	0	2	10
28												2	11	4	3	0	2	14
29												2	22	4	3	0	2	3
30												2	17	4	3	0	2	15
31												2	2	4	3	0	2	22
32
Hoja4

Thank you all

Regards,
Moti

 

[motilulla]

Hello,

Here is an another simple example I think I am clearer now I want to make all combinations with only row 3 (9 numbers) I have made manually with number 0 please I need VBA help which can make combination with rest of the row 3 (numbers 9-2-1-3-8-5-48 and 19) like same way as demonstrated wit 0

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2		n1	n2	n3	n4	n5	n6	n7	n8	n9		C1	C2	C3	C4	C5	C6	C7
3		0	9	2	1	3	8	5	48	19		0	1	4	3	0	2	5
4		1	0	4	8	29	11	22	17	2		0	0	4	3	0	2	5
5		4	9	0	11	2	5	3	7	15		0	4	4	3	0	2	5
6		3	4	8	0	6	10	49	2	1		0	8	4	3	0	2	5
7		0	10	3	5	2	24	63	1	11		0	29	4	3	0	2	5
8		2	21	0	14	13	16	1	7	5		0	11	4	3	0	2	5
9		5	1	0	27	10	14	3	15	22		0	22	4	3	0	2	5
10												0	17	4	3	0	2	5
11												0	2	4	3	0	2	5
12
13												0	1	4	3	0	2	5
14												0	1	9	3	0	2	5
15												0	1	0	3	0	2	5
16												0	1	11	3	0	2	5
17												0	1	2	3	0	2	5
18												0	1	5	3	0	2	5
19												0	1	3	3	0	2	5
20												0	1	7	3	0	2	5
21												0	1	15	3	0	2	5
22
23												0	1	4	3	0	2	5
24												0	1	4	4	0	2	5
25												0	1	4	8	0	2	5
26												0	1	4	0	0	2	5
27												0	1	4	6	0	2	5
28												0	1	4	10	0	2	5
29												0	1	4	49	0	2	5
30												0	1	4	2	0	2	5
31												0	1	4	1	0	2	5
32
33												0	1	4	3	0	2	5
34												0	1	4	3	10	2	5
35												0	1	4	3	3	2	5
36												0	1	4	3	5	2	5
37												0	1	4	3	2	2	5
38												0	1	4	3	24	2	5
39												0	1	4	3	63	2	5
40												0	1	4	3	1	2	5
41												0	1	4	3	11	2	5
42
43												0	1	4	3	0	2	5
44												0	1	4	3	0	21	5
45												0	1	4	3	0	0	5
46												0	1	4	3	0	14	5
47												0	1	4	3	0	13	5
48												0	1	4	3	0	16	5
49												0	1	4	3	0	1	5
50												0	1	4	3	0	7	5
51												0	1	4	3	0	5	5
52
53												0	1	4	3	0	2	5
54												0	1	4	3	0	2	1
55												0	1	4	3	0	2	0
56												0	1	4	3	0	2	27
57												0	1	4	3	0	2	10
58												0	1	4	3	0	2	14
59												0	1	4	3	0	2	3
60												0	1	4	3	0	2	15
61												0	1	4	3	0	2	22
62
Hoja2

Please help

Thank you all

Excel 2000
Regards,
Moti

 

[motilulla]

Hello, Please ignore this thread I am not clear with my question sorry for the trouble I will think again and post it again correctly

Thank you all

Regards,
Moti