Countif using Wild Card Characters

N

nebb

Objective: Trying to count the total number of times a character appear
in all cells within an array,

Assume the following data:
Cell A1 = 123
Cell A2 = 234
Cell A3 = 345
Cell A4 = 432
Using the formula =countif(A1:A4,”*3*”), I would assume this would giv
me the count of the number of times the digit 3 appears within th
array, therefore in the example shown above, I would expect to see a
returned since the number 3 appears 4 times.. Instead, I get a count o
Zero (0).

On another worksheet, using this formula (on different data than show
above) gave the correct answer until I changed the data in the array
Deleting a number in one of the cells in the array, correctly resulte
in a corresponding decrease by 1 in the count result. However, adding
a number in a cell in the array would not result in an increase of one
but instead, the result would stay the same as before I added th
number.
Am I overlooking something or is this formula with the asterisk no
suppose to work in the manner I am using it???? I am using Exce
2000.


A separate Forum operational question: If I get a response t
my submitted Thread and then I want to provide additional data to th
responder, how do I go about this
 
S

Sloth

I think you will need to format the cells as text to use that formula. If
you don't want to change the format, you can use this formula instead...

=SUMPRODUCT(--ISNUMBER(FIND("3",A1:A4)))
 
Top