Case: I have a checklist with 6 checkboxes.

Goal: to calculate number of checkboxes which are checked.

Idea:

- For each checkbox have an equation in which you check if a checkbox is not blank and then set the number to 0 (if blank) or 1.
- another equation to sum up the values of each of the previous equations.

So suppose you have 6 checkboxes and 3 are checked, you would get the number 3 (of 6)

Alas i tried to set-up an equation but checkboxes do not show-up in the equation fields you can use. So again out of ideas.

Someone else has an idea?

Thanks