Formula to count if cells do not contain intact

madison.s

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?

Paul Newcome

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")