countifs

[shatibi]

Hello,

I have a question. I have a spreadsheet in which I'm using various forms of countifs, like this one:

=COUNTIFS(B2:B36,">2390000",B2:B36,"<=2550000",G2:G36,"Billing"), etc.

But I want the cell to be blank if the answer is zero. I've tried various combinations of if clauses, but can't get to the right formula.

Please help!

 

[Aladin Akyurek]

Hello,

I have a question. I have a spreadsheet in which I'm using various forms of countifs, like this one:

=COUNTIFS(B2:B36,">2390000",B2:B36,"<=2550000",G2:G36,"Billing"), etc.

But I want the cell to be blank if the answer is zero. I've tried various combinations of if clauses, but can't get to the right formula.

Please help!

You could custom format the formula cell as e.g.,

[=0]"";General

 

[shatibi]

Great, thank you!

 

[Aladin Akyurek]

Great, thank you!

You are welcome. Thanks for providing feedback.