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.