Combination of Numbers that equal a certain Sum

Hi everyone, I have an interesting problem which I still can't find a solution to even in other forums. Hope someone can help. Anyway, I'd like to generate a list that exhausts all possible combinations for a given sum with a given number of columns. For example, I would like to know all the possible combinations by which I can arrive at 50 using 7 columns.

1st combination
Col 1: 49
Col 2: 1

2nd combination
Col 1: 49
Col 2: 0
Col 3: 1

3rd combination
Col 1: 49
Col 2: 0
Col 3: 0
Col 4: 1

(...until col 7)

I'd also like to have:
Col 1: 48
Col 2: 1
Col 3: 1
Col 4: 0
col 5: 0
col 6: 0
col 7: 0

Col 1: 48
Col 2: 2
Col 3: 0
Col 4: 0
col 5: 0
col 6: 0
col 7: 0

and so on.... (Hopefully my example is clear cause im having problems pasting a table here)

I do hope that if anyone comes up with a code, it will be generic (i.e. not just for sum of 50 or column of 7). I actually wish to use this even for sum of 100. Thanks for the help, it will be greatly appreciated

Hello darkwinged,

Maybe the attached WorkBook will give you a Start.

Please also see the "Please consider notes at the bottom of this post.

Hello darkwinged,

Simple formulas in excel won't allow you to get all the combinations, but it might be the only way to go.

If you want to exhaust all the possible combinations by which you can arrive at say only 37 using 7 columns, would require 94,931,877,133 Cells using 13,561,696,733 Rows.

Can you imagine how many Cells/Rows the number 50 or 100 would require?

I don't think Spreadsheets are that big yet, Let alone looking through that many Cells/Rows to find what you may like.

Anyway, Good Luck - Maybe I am wrong - And just maybe some Forum Guru can prove it possible.

Hello darkwinged,

That would still have to cater for 3125 possible combinations, and quite frankly, I do not know how to Code for that.

Sorry, but I surrender. Would love to see it done though.