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 ?
Help Article Resources
Check out the Formula Handbook template!