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.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!