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


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




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!