Using COUNTIF but blank cell if zero

[Ross_Langmead]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I'd like to count how many times "x" appears in a column but leave the cell blank if the count comes to zero.

I've had a go with =IF(COUNTIF(J3:J37,"x&quot>0,(COUNTIF(J3:J37,"x&quot,"&quot) but am getting an error message.

What am I doing wrong?

Thanks in anticipation

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel I'd like to count how many times "x" appears in a column but leave
the cell blank if the count comes to zero.

I've had a go with =IF(COUNTIF(J3:J37,"x")>0,(COUNTIF(J3:J37,"x"),""))
but am getting an error message.

What am I doing wrong?

Thanks in anticipation

the formula should be:
=IF(COUNTIF(J3:J37,"x")>0,COUNTIF(J3:J37,"x"),"")

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I'd like to count how many times "x" appears in a column but leave
the cell blank if the count comes to zero. <br><br>I've had a go with
=IF(COUNTIF(J3:J37,&quot;x&quot>0,(COUNTIF(J3:J37,&quot;x&quot,&quot;&quot
) but am getting an error message. <br><br>What am I doing wrong?
<br><br>Thanks in anticipation

It'd sure be easier if people posted text instead of html.....

So what is the error message?
What does COUNTIF(J3:j37,"x") all by itself return?

Try this....
IF (ISNUMBER(COUNTIF(J3:j37,"x")), COUNTIF(J3:j37,"x"),"") and set
your spreadsheet to not display zero values. OR....

IF (ISNUMBER(COUNTIF(J3:j37,"x")),
IF(COUNTIF(J3:j37,"x")>0,COUNTIF(J3:j37,"x"),""),"")

 

[John McGhie]

Hi Carl:

Anyone sending from "@officeformac.com" is sending through the web
interface.

They do not have a choice: the server converts to HTML before onpassing to
the NNTP server.

Cheers

=IF(COUNTIF(J3:J37,&quot;x&quot>0,(COUNTIF(J3:J37,&quot;x&quot,&quot;&quo>>
t

It'd sure be easier if people posted text instead of html.....

So what is the error message?
What does COUNTIF(J3:j37,"x") all by itself return?

Try this....
IF (ISNUMBER(COUNTIF(J3:j37,"x")), COUNTIF(J3:j37,"x"),"") and set
your spreadsheet to not display zero values. OR....

IF (ISNUMBER(COUNTIF(J3:j37,"x")),
IF(COUNTIF(J3:j37,"x")>0,COUNTIF(J3:j37,"x"),""),"")

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!