return sporadic numbers in a cell-area from a spesific number

[farmer]

Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 -
i want to spread out sporadic numbers in the 30 cells and the summary must
be 200.I know you proffesionals out there can tell me!
I`ll be pleased

Peter

 

[Gary''s Student]

In A1 thru A29 enter:

=RANDBETWEEN(1,10)

In A30 enter:

=200-SUM(A1:A29)

 

[farmer]

Don`t work - i get #name?

In A1 thru A29 enter:

=RANDBETWEEN(1,10)

In A30 enter:

=200-SUM(A1:A29)

 

[Gary''s Student]

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in. Use:

Tools > AddIns...

 

[farmer]

Ok now but the solution doesn work - the number i put in cell a 31 must be
ditributed randomly from cell A1 to A30 so the summary of A1 to A30 must be
like A31