I generated random number (1-6) as in DICE
How do I count the number of times a 1, 2, 3, ...... 6 occurs when I run it
for, let say, 1000 times.

What function should I use to keep these counts?

=COUNTIF(A:A,1)
=COUNTIF(A:A,2)
etc.

HTH
Jason
Atlanta, GA

-----Original Message-----
I generated random number (1-6) as in DICE
How do I count the number of times a 1, 2, 3, ...... 6
occurs when I run it
for, let say, 1000 times.

What function should I use to keep these counts?
.

What you have below does not do cummulative counts.
Let say I roll the dice 100 times, and I want to know how many times
a 1,2,3,....6 appears.

Let say I am looking at the 2, it counts the first time a 2 appears, but any
time another number appears, the counter for "2" reads "0".

I want something that records these counts, cummulatively...
Thanks,

OSJ


"Jason Morin" wrote:

=COUNTIF(A:A,1)
=COUNTIF(A:A,2)
etc.

HTH
Jason
Atlanta, GA

-----Original Message-----
I generated random number (1-6) as in DICE
How do I count the number of times a 1, 2, 3, ...... 6
occurs when I run it
for, let say, 1000 times.

What function should I use to keep these counts?
.

To clarify the problem:

I am using RANDBETWEEN(1,6) to simulate rolling the DICE.
I have six Counters: [ ] [ ] [ ] [ ] [ ] [ ]
reprensenting: 1 2 3 4 5 6

When I roll the DICE 100-times what I have looks similar to:
[0] [0] [0] [1] [0] [0]
1 2 3 4 5 6

It keeps the last count that meets the condition, and zeroes all others.
The COINTIF (A:A, 1) function, for example, returns a zero when any other
number appears (when the comditon is not met).

Thanks.....



"Jason Morin" wrote:

=COUNTIF(A:A,1)
=COUNTIF(A:A,2)
etc.

HTH
Jason
Atlanta, GA

-----Original Message-----
I generated random number (1-6) as in DICE
How do I count the number of times a 1, 2, 3, ...... 6
occurs when I run it
for, let say, 1000 times.

What function should I use to keep these counts?
.