How to count checked tick boxes in multiple columns in Numbers?

Let's say you have four contiguous columns with checkboxes.

One approach would be to do this:

Add a helper column with this formula in F2, filled down:

=IF(AND(COUNTA(B2:E2)>0,COUNTIF(B2:E2,TRUE)=COUNTA(B2:E2)),1,0)

This inserts a 1 if all the checkboxes on that row are checked, otherwise a 0.

Then sum that column.

Replace the , with ; in the formula if your region uses , as a decimal separator, i.e.,

=IF(AND(COUNTA(B2:E2)>0;COUNTIF(B2:E2;TRUE)=COUNTA(B2:E2));1;0)

SG

Assuming you mean count rows which have all checkboxes checked here is another approach that doesn't need a helper column.

=COUNTIFS(B,TRUE,C,TRUE,D,TRUE,E,TRUE)

Change the B,C,D,E to match your columns with checkboxes.

SG

Hi Jean,

Try this:

Table 1 has a Footer Row.

Formula in Footer Cell B8 is COUNTIF(B,TRUE)

Fill right.

Please call back with questions.

Regards,

Ian.