excel problem

[wilbasket23]

i have some questions regarding excel. i want to randomly select some number from a list and sum them. how would i be able to set a formula to randomly select some number.

[David_Jones]

You can create random numbers using the RAND function.

Why do you want to sum random numbers though?

If you create a random number from, say, 0 to 1, and them sum, say, 5 of them, isn't that the same as creating a random number between 0 and 5?

David.