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