Using COUNTIF with text
 

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 :(

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 :(

It works for me, and it isn't case-sensitive. Are you sure you don't have
leading or trailing spaces in this column?

On Mon, 7 Mar 2005 19:35:07 -0800, jodiek
wrote:

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 :(

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 :(

Thank you. That is the problem and i am working to repair it.

Best,
Jodie

"Myrna Larson" wrote:

It works for me, and it isn't case-sensitive. Are you sure you don't have
leading or trailing spaces in this column?

On Mon, 7 Mar 2005 19:35:07 -0800, jodiek
wrote:

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 :(

You're welcome !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"jodiek" wrote in message
...
Thank you. That did the trick!

Best,
Jodie