Count letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

In the range of A1-K1, I have letters A, B, C, D, F in the cells and I need
to count how many A, and B, and C, … are available?
How can I do this?
Thanks
 
Thanks for reply. I actually need to count A, A-, B, B-, I seems when it
counts A, it includes A- too. How can I avoid it?
 
Are you sure?

That Countif formula *should not* count "A-" as an "A".

How are the letters being entered into the cells?
Are they being keyed in, or are they the returns of a formula?

Is there *only* one letter in a cell?
 
=COUNTIF(A1:K1,"A")

As is, JMB's suggested formula works ok for me.
It doesn't pick up the "A-", only the "A".
Perhaps try it again?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Countifs/Sumproduct with mutil Or statement 3
Showing Letters For Column Headers Rather Thann Numbers ? 1
Counting number of items excluding duplicates. 1
COUNT QUESTION 2
Data Validation Problems with Charts 1
Counting characters in a cell 5
Scrabble Value calculation for Welsh words 0
Adding up letter values 11

Back
Top