Tally up all check boxes in a row

5

Aha, the blanks!

A somewhat clunky solution that comes to mind is:

IF(A,1,0) +
IF(B,1,0) +
IF(C,1,0) +
IF(D,1,0) +
IF(E,1,0) +
IF(F,1,0) +
IF(G,1,0) +
IF(H,1,0) +
IF(I,1,0) +
IF(J,1,0)

For each column, we ask “Is the column true?” note: IF(A, is a shorthand for IF(A=true,
If it is true, spit out a 1. Otherwise (i.e. if false or blank), spit out a 0.
And then add the next column’s result.

Edit: And then @Mario 's solution looks something like this I expect:

List(A,B,C,D,E,F,G,H,I,J).Filter(currentValue=true).Count()
1 Like