COUNTIF Formula for all occurances of X
 

Cells contain:

0 A B
1 X X1
2 X1 X AD
3 XI MX
4 REX OMTX
5 X M-X
TOTAL ? ?

I want a TOTAL count of any occurance with the 'X' in it. When I use "X*"
in my formula, it does count all X* occurances but when I try "*X*", it does
not count any.

COUNTIF Formula for all occurances of X
 

I used this equation with no problem

=COUNTIF(B26:B31,"*X*")

"YanYan" wrote:

Cells contain:

0 A B
1 X X1
2 X1 X AD
3 XI MX
4 REX OMTX
5 X M-X
TOTAL ? ?

I want a TOTAL count of any occurance with the 'X' in it. When I use "X*"
in my formula, it does count all X* occurances but when I try "*X*", it does
not count any.

COUNTIF Formula for all occurances of X
 

=countif(a1:A5,"*x*")
gives you 0??????

It gives me a count of the number of cells that contain at least one X.



YanYan wrote:

Cells contain:

0 A B
1 X X1
2 X1 X AD
3 XI MX
4 REX OMTX
5 X M-X
TOTAL ? ?

I want a TOTAL count of any occurance with the 'X' in it. When I use "X*"
in my formula, it does count all X* occurances but when I try "*X*", it does
not count any.

--

Dave Peterson