COUNTIF returning blank cell if value is 0

[Chand]

Hiya...

I've been using the following formula to count the number of cells containing criteria, eg 32.

=COUNTIF(April!G:G,"32")

If no cells contain 32 I get a result of 0. What I'd like is a formula that returns a blank cell if the result is zero.

I've tried various combinations but I'm not even sure if this is a COUNTIF function... any help would be appreciated!

 

[onlyadrafter]

Hello,

Try

=IF(COUNTIF(April!G:G,"32")=0,"",COUNTIF(April!G:G,"32"))

Has this solved the issue?

 

[The Tamer]

Hello Chand

Try

=if(COUNTIF(April!G:G,"32")=0,"",COUNTIF(April!G:G,"32"))

Cheers

Damian

 

[Chand]

Thanks Damian and onlyadrafter.... perfect thank you!!

 

[Mark W.]

...What I'd like is a formula that returns a blank cell if the result is zero.

Formulas can't return a blank cell... they can return a null string, "". Why don't you just format the cell containing the COUNTIF formula using...

0;;;

 

[Yogi Anand]

Hiya...

I've been using the following formula to count the number of cells containing criteria, eg 32.

=COUNTIF(April!G:G,"32")

If no cells contain 32 I get a result of 0. What I'd like is a formula that returns a blank cell if the result is zero.

I've tried various combinations but I'm not even sure if this is a COUNTIF function... any help would be appreciated!

Hi Chand:

You may want to have a rethink about having a formula to display a blank.

In case no cell contains 32, the effective count indeed is 0, if you don't want to display 0, then this is a formating issue ... in that case you can do one of two things ...

1) Custom Format the cell as ... [=0]"";General
2) use TOOLS|Options|View|Window_options ... uncheck Display_Zero_Values to not display Zero_values in the entire worksheet

 

[Chand]

...What I'd like is a formula that returns a blank cell if the result is zero.

Formulas can't return a blank cell... they can return a null string, "". Why don't you just format the cell containing the COUNTIF formula using...

0;;;

Thanks!

 

[jojorelos]

thank you very much for sharing your formula sir/mam onlyadrafter . i truly appreciate your help although i did not directly ask help regarding this, but when i try to look for help with the same problem i have in mind you've help me with it. thank you very much.