Need help using NOT in a COUNTIFS cross-sheet formula.
I think I am off my game. I cannot for the life of me figure out how to use NOT in a cross reference formula... I have a sheet with tons of data and am referencing a status column that has four options, blank, not started, in progress and complete. I want to count every row that is NOT complete. Here is what I have tried...
=COUNTIFS({Testing Sheet Range 2}, =NOT("complete"))
=COUNTIFS({Testing Sheet Range 2}, NOT("Complete"))
=COUNTIFS({Testing Sheet Range 2}, "NOT('Complete')")
Not sure what I'm missing and why it won't give me the results I need. Please help!
Comments
-
Try your second one with @cell = in the NOT function.
NOT requires a logical statement meaning This = That/This < That/This > That/etc.
=COUNTIFS({Testing Sheet Range 2}, NOT(@cell = "Complete"))
I ran a quick test with this and it worked (I assume):
=COUNTIFS({12 Week for Updates in Progress Range 1}, NOT(@cell = "Complete"))
It gave me a result of 345. It was a total of 657 lines, and I wasn't about to sit there and count them all. The point is... It gave me a number that seems like it should be accurate based on the overall status of the project plan I used for the testing (53%), so...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!
