Ah I see the problem
if your computer speed is not too bad you could try reversing the process - selecting a random number between 30 and 60, having =randbetween(1,x) formulas in cells a1:a5, and recalculating until the sum matches your random number. I did it with a macro and it took less than a second.
If you have a cell named "target" containing the formula
= randbetween(30,60)
and a cell named "fixed" to copy the value generated by that formula into
and a cell named "cellsum" with the sum of cells A1:A5
This macro will recalc the sheet until "cellsum" matches your chosen random number between 30 and 60
Bookmarks