Formula to count if cells do not contain intact

Options

Hello! I am trying to caculate how many cells in column "Condition" do not have the word intact in it.

This is the formula I am using but getting #unparseable

=Count([Condition]:[Condition])-COUNTIF([Condition]:[Condition],”Intact”)

Is there an error with the formula or one better?

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    The issue with your formula is the quotes. See how yours are slanted? They are called "Smart Quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula. You would need to retype them in the sheet itself or in a text editor such as Notepad (not Word).

    But I would still suggest a different formula that simply excludes "Intact" by saying to count cells that are not equal to "Intact".

    =COUNTIFS(Condtion:Condition, @cell <> "Intact")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!