Adding up checkbox's

Andre Benjamin Swart

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.

J. Craig Williams

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

 

Andre Benjamin Swart

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