How to remove 0's in blank cells when using COUNTIF

[TOM2RN]

This should be simple, but I can't locate an answer. I am using Excel 2010 and have been using the formula =COUNTIF(A1:A5, "X") to count the number of times it (the X) appears in my range. This always places a 0 in the cell unless the X occurs somewhere in the range. How can I have the cell remain blank until there is an occurence. or for that matter, remain blank if there is no occurrence? It's a bit annoying to see 0's in a bunch of cells on a page.

Thanks

 

[Aladin Akyurek]

This should be simple, but I can't locate an answer. I am using Excel 2010 and have been using the formula =COUNTIF(A1:A5, "X") to count the number of times it (the X) appears in my range. This always places a 0 in the cell unless the X occurs somewhere in the range. How can I have the cell remain blank until there is an occurence. or for that matter, remain blank if there is no occurrence? It's a bit annoying to see 0's in a bunch of cells on a page.

Thanks

If a real blank is necessary...

=IF(COUNTIF(A1:A5,"X"),COUNTIF(A1:A5,"X"),"")

You could also keep your current formula and custom format the formula cell as:

[=0]"";General

 

[T. Valko]

This should be simple, but I can't locate an answer. I am using Excel 2010 and have been using the formula =COUNTIF(A1:A5, "X") to count the number of times it (the X) appears in my range. This always places a 0 in the cell unless the X occurs somewhere in the range. How can I have the cell remain blank until there is an occurence. or for that matter, remain blank if there is no occurrence? It's a bit annoying to see 0's in a bunch of cells on a page.

Thanks

One way...

=IF(COUNTIF(A1:A5,"x"),COUNTIF(A1:A5,"x"),"")

 

[mikerickson]

You could format the cell with the custom format General;General;

 

[TOM2RN]

Thanks for the assistance.

 

[TOM2RN]

Thank you.