View Full Version : Excel.....Counting Letter in a column..

20-04-2001, 08:48 PM
I have a column, with just one letter per cell, either E G F or P.

I would like to count the number of times each character appears in the column.
I have a row for the results for each individual letter, so what i need is the formula.

I tried =Count('E',A10:A100) but this gave me a Zero result.



20-04-2001, 10:52 PM


COUNT function relates to cells with numbers