Generating a random number x times

[managerimankeli]

I need the RAND function to generate numbers x amount of times and sum them, where x is defined by the value of another cell. I tried this using the formula:
=A1*RANDBETWEEN(1;4)

The problem is that this generates one number only and then multiplies it, as opposed to generating many numbers and summing them. For example, if A1=3, I would want results ranging from 3-12, but the formula actually returns 3, 6, 9 or 12. How would I make the RANDBETWEEN function actually run A1 times?

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B
1	3	20
Data

Cell Formulas
Range	Formula
B1	B1	=SUM(RANDARRAY(A1,,1,12,1))

 

[KRice]

...a minor tweak: change the 1st 1 to a 3 for values between 3 and 12
edit: sorry...did I misinterpret the objective? A1 is the number of rows (the number of random numbers to generate). The next two numbers establish the lower and upper limits of those numbers. The last 1 means to generate integers. Do you want numbers between 1-12 or 3-12?

 

[managerimankeli]

How about [...]

Works great, thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.