# Thread: COUNTIF question - counting cells which contain a specific letter... Thanks:  24 Post #5272297 (1)Post #5279139 (1)Post #5278704 (1)Post #5276437 (1)Post #5279176 (1) Likes: 0

1. ## COUNTIF question - counting cells which contain a specific letter...

Is there a way to use the COUNTIF function to count cells if they contain a single letter - for example below, when a cell has the letter A, the count would be 3 in the top row

 3 12345 A4567 3546 23A78 765 2A6A8

I thought it would be easy using wildcards, but is doesn't seem to work... and I think having two letters in the cell makes things worse!

Thanks for helping!

2. ## Re: COUNTIF question - counting cells which contain a specific letter...

Maybe:
Sheet1

 A B C 1 3 2 3 3 12345 4 A4567 5 3546 6 23A78 7 765 8 2A6A8

Spreadsheet Formulas
 Cell Formula C2 =COUNTIF(A1:A8,"*A*")

Excel tables to the web >> Excel Jeanie HTML 4

3. ## Re: COUNTIF question - counting cells which contain a specific letter...

I tried that - but forgot the "" lol... thank you!

Is there a way to count cells which contain a number of different letters, or even any kind of alphabetical character?

4. ## Re: COUNTIF question - counting cells which contain a specific letter...

Originally Posted by Aitch
I tried that - but forgot the "" lol... thank you!

Is there a way to count cells which contain a number of different letters, or even any kind of alphabetical character?
You are welcome - thanks for the reply. Can you be a bit more descriptive on your new question and maybe provide a few examples of what you want to do?

5. ## Re: COUNTIF question - counting cells which contain a specific letter...

Yup!

 5 123456 12A34B 1CC345 1ABCD5 111222 ABCDEF 123123 123EF6

So in the column, there are 5 cells which contain letters - is there a way to use COUNTIF to find this value?

6. ## Re: COUNTIF question - counting cells which contain a specific letter...

Assuming all of the cells are not formatted as Text...

=COUNTA(A2:A9)-COUNT(A2:A9)

7. ## Re: COUNTIF question - counting cells which contain a specific letter...

Originally Posted by Rick Rothstein
Assuming all of the cells are not formatted as Text...

=COUNTA(A2:A9)-COUNT(A2:A9)
If your assumption is correct then we can also use:

=COUNTIF(A2:A9,"?*")

though note that your count will also include any null strings ("") within the range, should there be any.

Regards

8. ## Re: COUNTIF question - counting cells which contain a specific letter...

Yes, the formatting is Text... dangit!

Is it still possible to do somehow?

9. ## Re: COUNTIF question - counting cells which contain a specific letter...

Try

=SUMPRODUCT(--ISERROR(--(0&A2:A9)))

10. ## Re: COUNTIF question - counting cells which contain a specific letter...

Originally Posted by Phuoc
Try

=SUMPRODUCT(--ISERROR(--(0&A2:A9)))
Tried but doesn't seem to work... thank you anyway!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•