checkboxes

  • Thread starter Thread starter nathan
  • Start date Start date
N

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!
 
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.
 
Back
Top