Thank you. That did the trick!

Best,
Jodie

"Max" wrote:

Try: =SUMPRODUCT(--(TRIM(F1:F163)<"ENGLISH"))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"jodiek" wrote in message
...
I am using COUNTIF to determine the number of students who do not speak
English. I have 163 rows and about 1/2 are languages other than English
but
the formula =COUNTIF(F1:F163,"<ENGLISH") comes up with 162 as the result.
Other worksheets seem to be able to use this formula. I'm sure it's
something in the text but I can't figure out what is is :(