Excel: Generate Random Numbers That Add Up to a Fixed Sum / Value Eg. Add up to 100.

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial I explain how to create a series of random numbers that sum up to a specific value. For example 10 random numbers that sum up to 100.

Credit Chester Tugwell