Countifs with blank "0" Value

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:

Best Answer

  • Christian Graf
    Christian Graf ✭✭✭✭✭
    edited 01/05/23 Answer ✓

    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!

Answers

  • Christian Graf
    Christian Graf ✭✭✭✭✭
    edited 01/05/23 Answer ✓

    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 that worked, thanks a million!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!