COUNTIF Formula for all occurances of X

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

=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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumproduct or Countif - Counting Occurances within a Date Range	J_L_G	Microsoft Excel Worksheet Functions	2	17th Mar 2009 07:42 PM
countif formula to find the occurances of a number that is greater than one number but less than another	steveo	Microsoft Excel Misc	3	8th Jul 2006 02:04 AM
Creating a formula that counts occurances	=?Utf-8?B?c21vdXRzYXQ=?=	Microsoft Excel Discussion	2	8th Dec 2005 08:29 PM
how do I compare occurances of countif of two values	=?Utf-8?B?U2VhIEpheQ==?=	Microsoft Excel Misc	1	4th Jul 2005 09:09 AM
Countif and Multiple occurances	=?Utf-8?B?am9hbm5sd2VzdGZpZWxk?=	Microsoft Excel Worksheet Functions	4	15th Oct 2004 05:29 PM