How do I count the number of each number in a column?
Thank you so much...very useful!
"Peo Sjoblom" wrote:
=COUNTIF(A2:A10,2)
to count 2's as long as they are the only number in the cell
--
Regards,
Peo Sjoblom
"Shelby" wrote in message
...
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!
|