recording continuously changing data in excel.

[ffffrrrreeeeaaaakkkk]

Hi.
I am try to build a frequency table in excel 2007 to record the outcome of two excel built rolling dice for a school homework.
I have tried using different functions like "=countif(" to no avail.
I want the table to automatically record in separate cells how many times each possible outcome appears in 100 rolls of the dice.

All help appreciated.

File attached if you need a visual aid to help. Press F9 to roll dice.

[darkyam]

Welcome to the forum. Please take a minute to read the rules and then modify your title in accordance with rule 1. Thanks.

[shg]

To avoid the use of VBA and iteration, in some cell and copy down 100, 1000, 10000, ... rows,

=RANDBETWEEN(1,6) + RANDBETWEEN(1,6)

Then apply your FREQUENCY or COUNTIF function to that data.

[ffffrrrreeeeaaaakkkk]

Now solved, I changed the iteration to 1-1 and used the formula "=IF(G$8=5,B13+1,+B13)"

Working file attached.