Sum checkbox columns horizontally

Platform discussions
1

Hello, I am trying to sum 15 columns based on whether they have a check in the checkbox column. I keep getting an error with the sum formula.

2

Hi Tamara,

The SUM column won’t work in that way, since it doesn’t return a 1 or 0 but a string “true” or “false”.

Here’s one way of achieving this:

LEN(
	SUBSTITUTE(
		CONCATENATE(
		    {Check A},
		    {Check B},
		    {Check C}
		),
	    "FALSE",
	    ""
	)
)/4

This removes all the “False” returns and just gives you “TRUETRUETRUE” (as many times as there are checked boxes), then it divides the length of the result by 4.

You of course need to add all your checkbox columns separated by columns in the CONCATENATE function.

Let me know if that helps!

1 Like