Google Sheet - Count Random Average

Question

Number Of Invoice |   From   |   To   | Total

       10         |   $25    |  $100  |   ?

I want the Total column to fill with the average number of 10 invoice with each invoice random between the from and to column.

Whats is the formula for that ?,

Answer 1

If I understand your question correctly, you want to

Get the sum/average of 10 randomly generated numbers between 25 and 100

For the average

=AVERAGE(ARRAY_CONSTRAIN(ARRAYFORMULA(RANDBETWEEN(SEQUENCE(100,1,25,1),100)),10,1))

For the sum

=SUM(ARRAY_CONSTRAIN(ARRAYFORMULA(RANDBETWEEN(SEQUENCE(100,1,25,1),100)),10,1))