Thread: COUNT QUESTION
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default COUNT QUESTION

Hi Jay
=COUNTIF(A:A,"A")
will count all occurrences of "A" and "a"
or if you have entered your A, B C in cells in say column C
=COUNTIF(A:A,C1)
Copy down as required
--
Regards
Roger Govier

"JAY" wrote in message
...
All I want to do is COUNT how many times a letter appears in a column. I
have
made up a key using A, B, C, etc. E.g.: count how many times the letter
A
appears in a column, how many times the letter B appears, etc.

Thanks
--
JAY