Countif "#INVALID OPERATION"
Hi
Im trying to count all "#INVALID OPERATION" in order to catch if someone has enter an invalid character etc in a cell which needs to be added up.
I have tried multiple things without success.
The following is using the New "contains" function which returns a larger count than it should.
=COUNTIF({O_Eq_Total_Hrs}, (CONTAINS("INVALID", {O_Eq_Total_Hrs})))
Any help would be appreciated
thanks
Comments

I would modify the formula creating the error by wrapping it with an IFERROR function.
=IFERROR(INSERT YOUR FORMULA WITHOUT THE EQUAL SIGN HERE, "Error")
Then you could count if "Error" was appearing in the results. I don't think errors are actual data that can be counted. Wrapping the error in the IFERROR formula will give you data to count.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!