Thread: countifs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default countifs

You can put the countif inside an if

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

"Forza MIlan" wrote:

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.