COUNTIF Exclude

Options

I'm trying to exclude a column that has item checked with a checkbox from a result, but I'm getting an UNPARSEABLE error. It works fine until I add ", NOT..."

Any guidance would be appreciated.

=COUNTIF({Resource Request with Range 2}, [Primary Column]@row), NOT({Resource Request with Range 3} = "is unchecked")

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi John, Yes, 0 equals unchecked. I noticed a paren out of place and your need to use COUNTIFS. Try:

    =COUNTIFS({Resource Request with Range 2}, [Primary Column]@row, {Resource Request with Range 3}, @cell=0)

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!