# Countifs with blank "0" Value

Options
✭✭✭

Hi

I am trying to put a formula together that will return blank if the value is zero based on 2 criterion.. example

=COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified" > 0 "")

So basically if the value of unqualified is zero, I want the cell to be blank.. any tips?

Tags:

• ✭✭✭✭✭
Options

If I am understanding you correctly, if the countifs of unqualified returns a zero count you want the cell to return blank?

=IF(COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified") = 0, "", COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified"))

Or are you asking to return a blank if any value in {Range 3} has a zero in it?

=IF(COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, = 0) > 0, "", =COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified"))

Hope this helps!

• ✭✭✭✭✭
Options

If I am understanding you correctly, if the countifs of unqualified returns a zero count you want the cell to return blank?

=IF(COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified") = 0, "", COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified"))

Or are you asking to return a blank if any value in {Range 3} has a zero in it?

=IF(COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, = 0) > 0, "", =COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified"))

Hope this helps!

• ✭✭✭
Options

@Christian Graf that worked, thanks a million!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!