Roulette Stats_Something Complex for a newbie

[cu19x]

Hello to all,

I have no experience on programming or very complex formulas, but I want to get something in which I will press the number (or enter it manually to a cell somewhere) of which the ball lands every time and the excel could count (result on a specific cell)
1) how many times each number has came
2) how many times each column has came
3) how many times each dousine (1st12, 2nd12, 3rd12) has came
4) how many times red or black has came
5) how many times 1-18 or 19-36 has came
6) how many times odds or even has came.

Thank you for any help.
George

[cu19x]

No suggestion on this?