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.
|