Generating numeric values in multiple cells using a single cell as reference.

Value of cell is dependent of sum including this value?
IMHO circular reference but maybe...

Hi,

In order to generate a random, non-biased distribution of 8 integers with a given sum, it would be necessary to first generate the set of all permutations of 8 integers having that sum and to then choose one of those permutations at random.

Since the number of such permutations for 30,236, for example, is greater than 10^100,000, this approach is clearly not a feasible one.

You will have to settle for a biased distribution, the extent of bias which you allow being proportional to the simplicity of the solution, I would imagine. One example of a heavily-biased formula approach would be (assuming e.g. 30,236 in A2) to enter:

In B2:

=RANDBETWEEN(1,A2-COLUMNS(C2:I2))

In C2:

=RANDBETWEEN(1,$A2-SUM($B2:B2)-COLUMNS(D2:$I2))

and copied to H2

In I2:

=A2-SUM(B2:H2)

Regards