How to generate a randomized range of numbers that sums into end parameter

I have a spreadsheet with a certain parameters: Range start: 1 Range end: 100 Randomization: N

Then there is a list with a size of 5. Excel generates me numbers with a step of 20 in each cell of that list. And if list size is changed, the step size will also change accordingly

I am trying to randomize every entry by +- of N so that an end sum would still be 100. Is there an elegant solution?