CountIf for check boxes
Good afternoon,
Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box?
Thanks
Best Answer
-
Yes, this is totally possible. The following formula will count all checked checkboxes. Just replace the checkbox column name in the formula with the name of yours.
=Countifs([Checkbox Column Name]:[Checkbox Column Name], =1)
Answers
-
Yes, this is totally possible. The following formula will count all checked checkboxes. Just replace the checkbox column name in the formula with the name of yours.
=Countifs([Checkbox Column Name]:[Checkbox Column Name], =1)
-
That will work, but to be honest you only need =COUNTIF([checkbox column]:[checkbox column],1)
You don't need the S on =COUNTIF and you dont need the = on the criteria
But it will still work with them
Kind regards
Debbie Sawyer Consultant & Training Manager
Smarter Processes mean happy people in successful businesses
-
While true, I make it a practice to use Countifs because there are commonly additional requirements that are required to add to countifs and it makes it very easy to add another range and condition if needed.
-
Thank you
They both work!
-
Glad we could be of help! Enjoy!
-
I have gotten myself into the habit of using COUNTIFS and SUMIFS as well. It's just easier to amend later on. When I used COUNTIF, I would add on some criteria without remembering the S at the end which would of course throw an error. I would then typically beat my head against a wall for days trying to figure out what is wrong and finding some complex workaround only to realize days (an a headache) later that it was just the S missing...
thinkspi.com
-
Hi guys
In reading both your comments I have realised that it is a great idea! I'm a stickler for following rules and I had never considered using a multiple conditon formula for a single condition! What am I like!? I think, like you, I might change my habit here
Sorry if I caused any offence, being new to the community I am learning what is and isn't acceptable!
Have a good day!
Kind regards
Debbie
-
Welcome aboard!
No offense taken on my side! Just stating some best practices I've developed along the way!
-
-
Ive followed the Countifs scenario shown, but I'm still getting #BOOLEAN EXPECTED error. any thoughts?
-
Can you copy/paste the exact formula you are using and describe your scenario a little further? What is it that you are counting?
Keep in mind that a COUNT formula will return a number, so it's best placed in a Text/Number type of column. This error usually means the formula is placed in a column that can't house that specific type of data (see here: Formula Error Messages)
If you're placing the formula in a checkbox type of column, these can house text or check boxes. You'll want to translate the numerical value coming from the formula into text by adding + "" to the end of the formula, like so:
=Countifs([Checkbox Column Name]:[Checkbox Column Name], =1) + ""
Let me know if this works for you!
Cheers,
Genevieve
-
Hi am followed the directions and I received BOOTLEAN EXPECTED error. I was reading that this error happens if the formula/text is placed in a checkbox cell. how do i bypass this?
-
boolean expected error*
-
You'll need to add +"" at the end. It will show the number, but it will be formatted as text.
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Hi everyone,
None of the above formulas worked out for me/ my case for some reason. I kept trying and changing variables and values from my reference sheet, but still struggling count those checked boxes. Also, every time I select my checkbox column, it represents it by "Range 1" or "Range 2"!
Regards,
Help Article Resources
Categories
Check out the Formula Handbook template!
