Countifs with blank "0" Value

Lisa B 2022

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?

Christian Graf

Hi @Lisa B 2022

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!

Christian Graf

Hi @Lisa B 2022

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!

Lisa B 2022

@Christian Graf that worked, thanks a million!