9/14/13
3:31 pm

# Forum Question: How Do I Create a Percentage In Numbers 09 From Adding Up Checked Check Boxes Out Of Total Check Boxes?

I am a teacher and I created many spreadsheets for students skills. For EX: i listed out the alphabet in columns and the date assessed in rows. I place a check in the box if the child identified the letter correctly, and leave it empty if they did not. How can I get the program to add up the total checked out of 26 possible> Please Help!
—–
Amy

### Comments: 3 Responses to “How Do I Create a Percentage In Numbers 09 From Adding Up Checked Check Boxes Out Of Total Check Boxes?”

9/14/13 @ 3:34 pm

For things like this, it is just a matter of finding the right functions. I usually just browse through them and pick out the ones that would be useful for the situation.
COUNTIF will give you the number of items in a range that meet criteria. Checkboxes are TRUE or FALSE, so the criteria would be as simple as “TRUE.”
COUNT will count the number of cells that have something in them, but a test shows they don’t count checkboxes. However, COUNTA counts anything. So that is a good way to get the total number of check boxes.
So the number of checked checkboxes divided by the total number of checkboxes would give us the answer.
As an example, if your checkboxes are in B2 to B12, then this formula would do it:
=COUNTIF(B2:B12,TRUE)/COUNTA(B2:B12)
Then just format that cell as “%” and you’ll get a percentage instead of a raw number.