I have columns containing numbers 1-6 (randomly). At the bottom, I do not
want to total, rather I wish to count up how many 1s, how many 2s, how many
3s etc.

I know there must be a way, but I can't see the wood for the trees!

Any help will be gratefully accepted.

Confused of Lichfield!