| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i count numbers that contain 02 (i.e.7029955)?
how do i count numbers that contain 02 (i.e.7029955)? I tried
=COUNTIF(C143:C154,"?02????") but it did not work. The system seems not to recognize the ? wildcard. |
|
#2
|
|||
|
|||
|
Try:
=SUMPRODUCT(--ISNUMBER(SEARCH("02",C143:C154))) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "caliche" wrote in message ... how do i count numbers that contain 02 (i.e.7029955)? I tried =COUNTIF(C143:C154,"?02????") but it did not work. The system seems not to recognize the ? wildcard. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| count cells with unique numbers | Excel Worksheet Functions | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Linear Mode
