Hello. This is my first forum entry ever, so I apologize in advance if I do something wrong.
Okay. Can you give me a formula for this?
First off, I have to pick 5 random integers between 0 & 50 that add up to a value.

For example, I need a value of 200, so any random combo can be made as long as it leads to 200.
(e.g., 50+50+50+50+0 or 21+34+50+45+50, ... )

I have to make this three times so that their sums would then lead to another value.

For example, I have now a value of 200 made by (50+50+50+50+0), I then need to add two more numbers to make a total of these of 500, so any random combo can also be made as long as it leads to 500, using the 200 as part of the formula. (e.g., 200+200+100, 200+150+150, 200+123+177)

Also, inside those other numbers are also 5 random numbers that compute to that number.

Example: Using, (200+123+177) so that it leads to 500, in 123 there is (25+25+25+25+23 or 20+20+21+22+40) and in 177 also 5 random numbers (50+50+50+27+0 or 45+40+13+50+29)

I thank you in advance. :D I know the a little above basic excel but I can't really understand professional excel jargon so please bear with me.