Thank you very much but it's a little complex what you have made. I need a simple one like this:

spins                                       468red     468black     597red    597black
spin1,spin2,spin3,spin4              1                0              2               1
spin5,spin6,spin7,spin8               1               3

its very much important for spins to be recorded horizontally rather than vertically so that if 32,1,32 comes when I write first 32  468 red becomes 1 then wen I write
1  597 red becomes 1 and wen i write 32 in 3rd spin cell  468 red becomes 2

Thank you very much again for your effort..

Sent you a PM. Thanks

Can anyone make me a spreadsheet or tell me how to make one?

I just need it to track 4 spins at a time like this:

spins    468red  468black  597red  597black
1234   


Any help appreciated..