How can I get the number of checkboxes checked in a single column ?

Hello,

I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case).

As you can see in the screenshots, I am actually able to see the sum of the checkboxes that are checked with a very simple SUM formula... but I guess there is a more efficent way to do so ?

Should I use a SUMIF or a COUNTIF ?

Many thanks,

Francis Comtois

Find more posts tagged with

Formulas

IT & Operations

Media & Entertainment

Comments

Andrée Starå

Hi Francis,

Try something like this.

=COUNTIF([A10 Transcode]:[A10 Transcode]; 1)

The same version but with the below changes for your and others convenience.

=COUNTIF([A10 Transcode]:[A10 Transcode], 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You could use a basic

=COUNTIFS([A10 - Transcode]2:[A10 - Transcode]2454, 1)

This will look at the checkbox column itself and eliminate the need for the helper column with 1's and 0's in it.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…