COUNTIF
 

Hi All,

I'm trying to do a COUNTIF in a row where some cells may contain an
"X"

My problem is that the "X" is placed via. an IF statement formula.

How can I add the number of "X"'s

Thank you very much for your help

Tom

COUNTIF
 

=COUNTIF(B1:B100,"X")
It does not matter if the X results from a formula or was typed into the
cell
If you are not getting it to work, look at the IF and make sure it is X and
not X with a space that is being entered
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"lehigh46" wrote in message
...
Hi All,

I'm trying to do a COUNTIF in a row where some cells may contain an
"X"

My problem is that the "X" is placed via. an IF statement formula.

How can I add the number of "X"'s

Thank you very much for your help

Tom