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
Check out the Formula Handbook template!