In cells C1 to C4 set

=INT(RAND()*6+1)

In the 'count' cell

=COUNT(C1:C4)
(this would always appear to be 4)

In the sum cell,

=SUM(C1:C4)

Did you intend the 'count' cell to be a count of the variety of numbers
given ?
(ie, for a 1, 2, 3, 3 selection to show 3)
or did you intend that cells C1 to C4 all have different 'random'
numbers ?




inkpassion Wrote:
What Im looking to do is have 2 cells 1 with the number of random
numbers and 2 the total value of these numbers. I need the random
numbers to be 1-6.

Something like this:

Coins Value
4 10

C1 C2 C3 C4
1 4 3 2


What would the formula be to accomplish this?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=401757