Dear All,

I am trying to generate a table for the following

I have 12 Columns

Jan Feb March Apr May etc....

Each month has minimum to maximum value i.e.

Jan Feb
Min - 7 Min - 6
Max - 11 Max - 8

and I have put the values (Max,Min and all in between) in columns like below.

Jan Feb
7 6
8 7
9 8
10
11

What I am trying to work out is how I can generate a table with all the combinations of numbers (Horizontal) from all the columns that add up to a certain value (i.e. 100).

In total there will be 136080000 different combinations, what I am interested in is
1) How many combinations will add up to a certain value (i.e. 100) and
2) What are those combinations

Thanks for your help.