countifs

[Guest]

Hi, when i use this function, "If criteria is an empty cell, COUNTIFS treats
it as a 0 value". I don't want this "0" to appear in the cells where the
criteria is not met, i want to be blank cell there. Is it possible.
Sorry for my English, its really suxx, but i hope you understand my question.

 

[Guest]

You can put the countif inside an if

=if(Countif(your code) = 0,"",Countif(your code))

 

[Guest]

Thanks a lot

You can put the countif inside an if

=if(Countif(your code) = 0,"",Countif(your code))