Thread: How do I count the number of each number in a column?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default How do I count the number of each number in a column?
=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!


Reply With QuoteReply With Quote