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

0

1 Answer 1

0

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

3
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Aug 14, 2020 at 15:48
  • Thx for the help ~
    – Marcel
    Aug 15, 2020 at 10:50
  • Thank you for taking the time to accept. Glad I could help. Aug 19, 2020 at 0:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.