COUNTIF Formula for all occurances of X

Y

YanYan

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.
 
D

Dave Peterson

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

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