Countifs no longer working
Hello,
I have a countifs formula that was working and is no longer...
This is for my "metrics" sheet so the information is being pulled from the Garage Access Issues Log onto another sheet so I can use it in a Dashboard.
I'm trying to count how many issues are showing as unresolved and not archived. Both the 'Resolved' and 'Archived' 'columns are checkboxes. Below is the formula I have.
=COUNTIFS({Garage Access Issues Log Resolve}, =0, {Garage Access Issues Log Archive}, 0)
Below are all the columns of the source sheet if that helps
Thank you in advance!!
Answers
-
Are you getting an error message?
-
There's no error message. It's just returning a value of 0 when there are 2 open issues
-
Ok. Let's try indicating "not equal to checked" instead of "equal to unchecked". It shouldn't make a difference, but I have seen that work sometimes.
=COUNTIFS({Garage Access Issues Log Resolve}, @cell <> 1, {Garage Access Issues Log Archive}, @cell <> 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!