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