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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Create a Percentage In Numbers 09 From Adding Up Checked Check Boxes Out Of Total Check Boxes?
Comments: 3 Responses to “How Do I Create a Percentage In Numbers 09 From Adding Up Checked Check Boxes Out Of Total Check Boxes?”
Comments Closed.
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.
Thank you for the help! Only problem is that I just learned to use numbers a few days ago, so I am not really familiar with what you are telling me to do. can you walk me through what to click on please etc. to get to the final result? Thank you so much!
I've got many tutorials on Numbers, perhaps best to start there:
http://macmost.com/using-spreadsheet-formulas-in-iwork-numbers.html
http://macmost.com/iwork-numbers-cell-formatting.html
http://macmost.com/tag/numbers