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