View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YanYan YanYan is offline
external usenet poster
 
Posts: 14
Default 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.