| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 8838 | 2001-04-20 09:48:00 | Excel.....Counting Letter in a column.. | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 11607 | 2001-04-20 09:48:00 | 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 |
Guest (0) | ||
| 11608 | 2001-04-20 11:52:00 | Try: =countif(A10:A100,'E') COUNT function relates to cells with numbers |
Guest (0) | ||
| 1 | |||||