COUNTIF Function
 

Using Excel 2002
I have rows of data with values in cells. I would like to count the number
of times the letter X appears in each column. Using the COUNTIF function in
the following manner reports a value of zero. The formula is in cell B22:
=COUNTIF(B2:B21,"X"). In column B there are ten instances of the letter X.
Can someone help? Thanks!

COUNTIF Function
 

Do those cells contain other letters or characters, including spaces?

If so and you want to count those, then you might try:
=COUNTIF(B2:B21,"*X*")

Regards,
Paul
--

"PatJennings" wrote in message
...
Using Excel 2002
I have rows of data with values in cells. I would like to count the
number of times the letter X appears in each column. Using the COUNTIF
function in the following manner reports a value of zero. The formula is
in cell B22: =COUNTIF(B2:B21,"X"). In column B there are ten instances of
the letter X. Can someone help? Thanks!

COUNTIF Function
 

You may have leading or trailing spaces

=COUNTIF(B2:B21,"*X*")



"PatJennings" wrote:

Using Excel 2002
I have rows of data with values in cells. I would like to count the number
of times the letter X appears in each column. Using the COUNTIF function in
the following manner reports a value of zero. The formula is in cell B22:
=COUNTIF(B2:B21,"X"). In column B there are ten instances of the letter X.
Can someone help? Thanks!

COUNTIF Function
 

Hi,
Your data may be contaminated with spaces.
To test for this, temporarily modify your formula to:
=COUNTIF(B2:B21,"*X*")
Does that change the count?
Regards - Dave.

COUNTIF Function
 

W O W ! ! !
Thanks to all for the immediate response. The adjustment to the formula did
the trick.

"Dave" wrote in message
...
Hi,
Your data may be contaminated with spaces.
To test for this, temporarily modify your formula to:
=COUNTIF(B2:B21,"*X*")
Does that change the count?
Regards - Dave.