ExcelBanter - how do i count numbers that contain 02 (i.e.7029955)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i count numbers that contain 02 (i.e.7029955)? (https://www.excelbanter.com/excel-discussion-misc-queries/36153-how-do-i-count-numbers-contain-02-i-e-7029955-a.html)

caliche

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.

Max

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.

All times are GMT +1. The time now is 04:28 PM.