Checkbox count in a table

1

I have a table with several columns with the checkbox format. What formula could I use to count the number of checked boxes (true) in the row?

2

To count the checkboxes in the row, you can actually just add them up.

=CheckboxColumn1 + CheckboxColumn2 + CheckboxColumn3

And if you need to count a column:

=YourTable.Filter(CheckboxColumn=true).Count()

Edit: This causes problems in certain circumstances, like blank checkboxes which are neither true nor false. See updated solutions here.

4 Likes