How to create all possible sums

[Ipinho100]

From A to D there can be numbers from 0 to 6. I want to create all the possible combinations so that every row sums to 6 using the numbers from 0 to 6. How can i do that?

[Pete_UK]

You could generate all possible combinations of the numbers down columns A to D (1296 of them) and then use column E to identify those that add up to 6, and then pick out just those numbers in columns to the right.

Hope this helps.

Pete

[rahi_feri]

Hi
here you are!