Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Adding up checkbox's
HI, everyone. Please assist here: How do I add the number of checked box's in a series of cells in a column. The answer is on the formula example sheet but I am not getting it. I have 7 questions that require a check to indicate yes or a non checked box to indicate no. I want to add the number of checked box's to get a score out of 7. If 5 box's are checked I want the number 5 to appear in my formula cell.
Comments

Andre,
The answer depends on several factors.
1. Are the 7 questions under a parent row?
2. Do you want to put the formula in the same column?
3. If 2 is no, is the column a Text/Number
Assuming your checkboxes are in a column named [Answer] and the parent row is in row 1.
For the simple case (1=yes, 2=no, 3=yes)
=COUNTIF(CHILDREN([Answer]1), 1)
Another simple case (1=no, 2=no, 3=yes)
=COUNTIF([Answer]2:[Answer]8, 1 )
And if you want to put the formula in the same (checkbox) column then
=COUNTIF(CHILDREN(), 1) + ""
or
=COUNTIF([Answer]2:[Answer]8, 1 ) + ""
will allow you to show a number greater than 1, but be aware that the number is really text. To use THAT number somewhere else, you'll need to use the VALUE() function.
Hope that helps.
Craig

Hi Craig, it did indeed I used this solution:
And if you want to put the formula in the same (checkbox) column then
=COUNTIF(CHILDREN(), 1) + ""
Thanks for taking the time to assist me