COUNTIF Formula to leave cell blank if target range cell is blank

[Detectiveclem]

Can someone help me correct the following formula.

=COUNTIF(J2,"*")

This correctly allows for the number 1 to appear in C2 when J2 has any text, however if J2 is blank, I want C2 also to be blank rather than showing 0.

I am aware I can set Excel not to display the value 0, but this is not suitable in this case as I need to see 0s in other columns.

All help appreciated.

 

[philwojo]

Try this:

=if(J2="","",[COLOR=#333333]=COUNTIF(J2,"*"))[/COLOR]

 

[Detectiveclem]

Try this:

=if(J2="","",[COLOR=#333333]=COUNTIF(J2,"*"))[/COLOR]

Hi Philwogo, no sorry this doesn't work

 

[philwojo]

Sorry remove the equal sign before the "countif" I forgot to pull that out.

 

[Jonmo1]

Perhaps

=IF(J2="","",1)

 

[Detectiveclem]

Perfect this works, thank you Jonmo1

 

[Jonmo1]

You're welcome.

 

[Detectiveclem]

Thank you, that’s it now. Appreciate you getting back to me.