Google Sheets – How to Count Random Average

formulasgoogle sheetsgoogle-sheets-arrayformula

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 ?,

Best Answer

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))

Related Topic