| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 :( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| COUNTIF text where there is more than one word in a cell | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions | |||
Threaded Mode
