checkboxes

[nathan]

I am trying to design a sheet with a number of different
checkboxes. I want to be able select checkboxes that apply
and have a formula at the end of the 'report' that will
tell me what percentage of the checkboxes were selected.
All I need to know is how to write the formula to give me
this percentage.

Any help would be greatly appreciated. I need to get this
spreadsheet done!!!! Thanks very much to anyone who can
help me!

 

[Danny]

Link all the boxes in one column. As you know, if the box
is checked, the link will indicate "true". Then add the
range of the link =CountA(range). It will give you the
total number of boxes. Then =countif(range,"true"). It
will give the the number of boxes checked. Then just
divide this number with the total which will give you the
percentage.

I wish I could give a shorter way to do it.