Excel: 4 Random Numbers that equal the same Total

Could you tell me how to make a Excel spreadsheet where I could make 4 random numbers that when added together will equal the same total? Such as the total is 21 so different 4 numbers would be 3558, 3648, 3747, 3828, etc So I want to have a different total each time and the 4 digit numbers will be automatically generated for me. Thank you ever so much!

This question generated 40 answers. To proceed to the answers, click here.

This thread is current as of January 21, 2014.

For more resources for Microsoft Excel