I have a formula that goes down col. A such that it inserts an "X"
(without quotes) in the cells if a certain criteria is met in data
inserted in other colums.

I am now trying to count how many cells in col. A have the "X" using
the SUMIF function. I keep on getting 0 (zero) as the result.

Here is the formula that I am using in cell B1:

=SUMIF(A1:A10000,"X")

What am I doing wrong?
--
tb