#### 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

Options
edited 12/09/19

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.

Tags:

• ✭✭✭✭✭✭
Options

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)

Another simple case (1=no, 2=no, 3=yes)

And if you want to put the formula in the same (checkbox) column then

=COUNTIF(CHILDREN(), 1) + ""

or

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

• edited 02/06/17
Options

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

This discussion has been closed.