Random Number Generator

Sgeffert22 I think the concept is possible but your criteria may be the issue. 125 numbers with a sum of 245 means an average of 1.96 and your allowed range is 1.1 - 2.1 so the average is almost at the top of the scale. Here is a solution that 'works' but quickly maxes out and you end up with many 2.1 values:

=LET(countdown,SCAN(C2,SEQUENCE(B2,,B2,-1),
LAMBDA(p,i,
LET(high,MIN(A3,p-(i-1)*A2),
         low,MAX(A2,p-(i-1)*A3),
          p-low-RAND()*(high-low)))),
DROP(VSTACK(C2,countdown),-1)-countdown)

what this does is start with the sum value and subtracts a random value in the available range until it reaches 0.  actually I just realized I need to adjust it to do only n-1 cases and the last case is the remainder.  but that said, it will keep adjusting the 'high' and 'low' range to make sure it is possible to reach that max and because of the range and values you picked it doesn't take long before it maxes out and returns 2.1 every time there after.