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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!