Sum up n randomly selected cells

[flixi]

I have the following problem:
I have one column with integers (from a binomial distribution) to which I will refer as "n". In a second sheet, I have another column of values (from a cost analysis). Now I want Excel to randomly pick n-cells (n = a given integer) from sheet 2 and sum-them up (within one cell if possible)
Is this possible?
So far I have managed to tell Excel to pick one random cell from sheet 2, or 5 times the same (but not 5 different ones)...


Thank you very much for your support!!!

 

[StephenCrump]

Welcome to the Forum!

Here's how you can calculate the sum of n random values:

B2: =RAND() copy down
n: = E3
E4: =SUMPRODUCT(--(B2:B11<=SMALL(B2:B11,n)),A2:A11)

I'm unclear though how this random number n relates to your binomial distribution in Sheet1?

Excel 2010
	A	B	C	D	E	F
1	Values	Random
2	1	0.718
3	2	0.982		Sum of	5	numbers
4	6	0.485		Random total	124
5	4	0.508
6	7	0.089
7	12	0.127
8	3	0.989
9	55	0.069
10	22	0.979
11	44	0.385
Sheet2