| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF(RANGE,"?") and search for contains
Of course it does, thanks for the correction
Mike "JE McGimpsey" wrote: Your last example will count any cell that contains a single character - the question mark acts as a wild card. To look for the question mark itself, you need to escape it with the tilde character: =COUNTIF(A1:A30,"~?") In article , Mike H wrote: try this =COUNTIF(A1:A30,"*Mexico*") and =COUNTIF(A1:A30,"?") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF "EVEN" numbers in a range | Excel Discussion (Misc queries) | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
