How to count cells that only have an "x" in the column to be counted

[Launchnet]

I have the following 2 formulas that I'm trying and all I get is #####. I only want to count cells that have an X in them.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

When I use the following code, it works correctly, but it also counts all values and I only want to count X's.

Please Login or Register  to view this content.

Thanks in advance for your help.

[martindwilson]

=wont countif work?
COUNTIF(N12:N5093,"x")

[Launchnet]

Yes, it counts correctly, but it displays a zero if there are no x's. I don't want zero's displayed.

I don't know how to us the =if code since it works will all the cells listed ?

Thanks

[martindwilson]

=IF(COUNTIF(N12:N5093,"x"),COUNTIF(N12:N5093,"x"),"")
or
IF(COUNTIF(N12:N5093,"x")=0,"",COUNTIF(N12:N5093,"x"))

[Launchnet]

Hi Martin D Wilson . . .

They both work very good.

2 questions.

1st . . . Why is there a black marker in the upper left corner of the cell if there is no qualifying count. It is just like the comment indicator which is Red and in the upper right.

Please Login or Register  to view this content.

2nd . . . What does the =0 represent in this formula ?

Thanks, I am sure that this will be the last of my questions on this posting.

[martindwilson]

COUNTIF(N12:N5093,"x")=0 is what it says. if x is not found then the total would be 0
the black triangle is something to do with error checking

Black triangle, upper-left corner of a cell indicates changes: Tools, Track changes, Highlight Changes

[Launchnet]

Good Morning Martin D . . .

Thanks for your reply.

Now I understand what the =0 does.

I went to the Tools as you suggested. It does not appear that there is a way of turning the black marker off. If there is, would you please let me know. I will close this as solved probably Tuesday.

[martindwilson]

what version of excel?

[Launchnet]

Thanks Martin D.

I use Excel 2003 . . . but, others will be using later versions. All I need is to turn the markers off in Excel 2003 at this time if possible.

[martindwilson]

try
tools/options/errorchecking tab
turn of enable background error checking

[Launchnet]

Good Morning Martin D . . .

Works like a charm. Some how this option had been turned on.

Thanks much.