CountIf for check boxes

BESP10BESP10 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
02/28/19 Edited 12/09/19

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

 

 

Previous1

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    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)

     

  • Debbie SawyerDebbie Sawyer ✭✭✭✭

    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 smiley

    Kind regards

    ​Debbie Sawyer Consultant & Training Manager

     

     

    Smarter Processes mean happy people in successful businesses

  • Mike WildayMike Wilday ✭✭✭✭✭

    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. 

  • BESP10BESP10 ✭✭✭✭✭

    Thank you 

     

    They both work!

    yes

     

  • Mike WildayMike Wilday ✭✭✭✭✭

    Glad we could be of help! Enjoy! 

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    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

  • Debbie SawyerDebbie Sawyer ✭✭✭✭

    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

  • Mike WildayMike Wilday ✭✭✭✭✭

    Welcome aboard! yes 

    No offense taken on my side! Just stating some best practices I've developed along the way! 

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Ditto, Debbie. winkyes

    thinkspi.com

  • Paulina GuerreroPaulina Guerrero ✭✭✭✭

    Ive followed the Countifs scenario shown, but I'm still getting #BOOLEAN EXPECTED error. any thoughts?

  • Hi @Paulina Guerrero

    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*

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Sarah Loewenthal

    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 PARTNER & CONSULTANT / EXPERT

    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.

  • Abe B.Abe B. ✭✭✭✭

    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,

Sign In or Register to comment.