On Jun 13, 5:57 am, Gary''s Student
wrote:
I need to add up 23 independent random numbers.

You are not very specific. From your example, it appears that you
want 23 random values between 0 and 1.


Is there a more compact array formula, or some form of SUMPRODUCT, that can
get the same result?

Not exactly the same, but I wonder if the following would satisfy your
needs.

=SUMPRODUCT(RANDBETWEEN(0,ROW(A65512:A65534))/ROW(A65513:A65535))

With Excel 2007 (I have Excel 2003), you should be able to substitute
65535 (and its derivatives; e.g., 65513 is 65535 - 22) with a larger
number. That should improve the random characteristics somewhat.


----- original posting -----

On Jun 13, 5:57*am, Gary''s Student
wrote:
I need to add up 23 independent random numbers. *My first try was:

=RAND()*23

This proved to be insufficient since it really only added the same random
value 23 times. *I can get a correct result with a helper column or with a
formula like:

=RAND()+RAND()+RAND()+RAND()+RAND()+RAND()………….

Is there a more compact array formula, or some form of SUMPRODUCT, that can
get the same result?

--
Gary''s Student - gsnu2007xx