CountIf for check boxes

BESP10

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

 

 

Mike 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)

 

Mike 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 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

Kind regards

​Debbie Sawyer Consultant & Training Manager

 

 

Smarter Processes mean happy people in successful businesses

Mike 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. 

BESP10

Thank you 

 

They both work!

 

Mike Wilday

Glad we could be of help! Enjoy! 

Paul 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...

Debbie 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 Wilday

Welcome aboard!  

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

Paul Newcome

Ditto, Debbie. 

Paulina Guerrero

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

Genevieve P.

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

Sarah Loewenthal

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?

Sarah Loewenthal

boolean expected error*

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!

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,