PDA

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.

Thanks.....John

jhw@xtra.co.nz

20-04-2001, 10:52 PM
Try:

=countif(A10:A100,'E')

COUNT function relates to cells with numbers