countifs

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
You can put the countif inside an if

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