I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbLongRandSumN

You need to generate 20 non-negative random integers which sum up to 100? Then I suggest to use my UDF below.

You can generate an arbitrary number of integers which sum up to a specified amount, and all generated integers are not smaller than another specified number:

sbLongRandSumN_Screen
sbLongRandSumN_Code

If you are interested in downloading a 27 KB Excel 2010 sample file go to my Download page, please.

Please notice that this function is a relative of the brownian bridge sbGrowthSeries and of sbRandSum1 which generates numbers of type Double which sum up to one exactly.

This function is used in my application sbGenerateTestData, for example.

Sulprobil   Get it done   Contact   Disclaimer   Download