ExcelBanter - countifs

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - countifs (https://www.excelbanter.com/excel-discussion-misc-queries/148921-countifs.html)

Forza MIlan

countifs

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.

joel

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.

Forza MIlan

countifs

Thanks a lot

"Joel" wrote:

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.

All times are GMT +1. The time now is 05:16 PM.