Countif function for unchecked box
Is there a way to run the countif function if a check box is unchecked? I see a command example for when it is checked, but I want to exclude any checked boxes as those would mess up my counts due to the negative value associate when it is checked.
Answers
-
Looks like I was able to reverse engineer this and determine that using a 0, instead of a 1 allowed the function to work as I intended it.
-
Hi @MattW PDC
I'm glad you were able to figure this out! Yes, 1 represents "checked" in a formula and 0 represents "un-checked". You can also use true and false, but I personally prefer 1 and 0.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi
I tried using the countif for unchecked but the amount coming back to me is wrong.
Have checked to source sheet to make sure
=COUNTIF({Reconcile 2}, false)
-
The first thing I'd check here is the {range} to make sure it's pointing at the correct checkbox column. You can also try using 0 instead of false to see if that helps, too:
=COUNTIF({Reconcile 2}, 0)
If you're still seeing an incorrect number, my next test would be to add a filter in your source sheet to compare the number of rows in the filter versus the value that the formula is bringing back. If none of this has helped, it would be useful to see a screen capture of your source sheet, but please block out sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I have this same problem, and it's looking like the formula in the Sheet Summary is counting the empty rows that are at the bottom of the sheet as well. When I used the filters to see how many are unchecked, it's showing the correct number.
-
@Jayy S. You can subtract 10 from the final COUNTIFS or you can reference another field in the sheet that will have something in every row aside from those ten at the bottom.
-
That is absolutely ludicrous to have to create so many workaround when the formula should be counting only unchecked boxes. It's also ridiculous that 10 blank rows are automatically added and clogging up the view.
-
@Jayy S. There isn't the need for "so many" workarounds. It one or the other, and the one is as simple as subtracting 10. I'm also not sure how blank rows are clogging up the view when they are at the bottom of the sheet and blank. It is much less "clogging" than what you would find in programs such as Excel.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!