# 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. ## Re: COUNTIF question - counting cells which contain a specific letter...

Originally Posted by jtakw
Hi,

Regarding Post # 23...

Just pointing out, formula provided by Phouc in Post # 9 uses ISERROR (which evaluates to TRUE/FALSE, and hence his use of the double unary -- ), Not IFERROR, so No "Value if error" is needed or even should be added, formula will end up invalid due to "too many arguments".
Will it be my excel version (2016)?
I can not enter the formula:

"You've added too few arguments for this function"

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

You've probably typed IFERROR, use ISERROR or just copy/paste Phuoc's formula from Post # 9

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

Originally Posted by jtakw
You've probably typed IFERROR, use ISERROR or just copy/paste Phuoc's formula from Post # 9

duh

the formula works!

(I can not copy and just paste, I have to translate the formulas, my excel is in Spanish )

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

Dante, are you aware of this site which translates formulas? It may help.

https://en.excel-translator.de/translator/

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

Originally Posted by Eric W
Dante, are you aware of this site which translates formulas? It may help.

https://en.excel-translator.de/translator/
Thanks Eric, I'm sure I'll consider it

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

Originally Posted by Eric W

This array formula will only count cells with at least 1 letter of the alphabet, case disregarded:

=SUM(SIGN(MMULT(IFERROR(SEARCH(CHAR(COLUMN(INDIRECT("A:Z"))+64),A2:A9),0),ROW(INDIRECT("1:26")))))

confirmed with Control+Shift+Enter. Numbers and other characters and empty cells are not counted.

Is there a way to do it, without using an array formula?

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

Originally Posted by Rick Rothstein
So a value like 12//--3/-/4 would be okay????
Yup!

I know, it's a very strange request!

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

Not in a native Excel formula. The other way to do it would require a UDF, which needs VBA.

To try that, open a copy of your workbook. Press Alt-F11 to open the VBA editor. Press Alt-IM. In the window that opens, paste this code:

Code:
```Public Function CountAlpha(ByVal target As Range)
Dim x As Variant

For Each x In target
If x.Value Like "*[A-Za-z]*" Then CountAlpha = CountAlpha + 1
Next x
End Function```
Press Alt-Q to close the editor. Now enter the formula as:

=CountAlpha(A1:A9)

Let us know if that helps.