How do I tally checked check boxes in an Excel spreadsheet?
 

I want to create a user-friendly grade sheet for an exercise within a course.
Each of 4 days of student work is considered separately for this score and
all days are rated on a Likert scale. The check boxes seem appealing as an
option to make this form as simple as possible for the faculty so that the
scoring methods will be as consistent as possible from one member of the
teaching team to another - but I cannot figure out how to make these work
with my formulas.

Any ideas?

How do I tally checked check boxes in an Excel spreadsheet?
 

I would use a seperate worksheet to link the checkboxes to.
If a check box is checked the cell will display true.
Then if you set these up with a nice structure
you can use formulas linked to these cells to formulate values.

On second thought syou might be better with (radio) option buttons as
you will only require one of the five to be selected.
checkboxes allow for upto 5 to be selected.

let me know if you want me to publish an example

somethinglikeant




acpharmd wrote:

I want to create a user-friendly grade sheet for an exercise within a course.
Each of 4 days of student work is considered separately for this score and
all days are rated on a Likert scale. The check boxes seem appealing as an
option to make this form as simple as possible for the faculty so that the
scoring methods will be as consistent as possible from one member of the
teaching team to another - but I cannot figure out how to make these work
with my formulas.

Any ideas?

How do I tally checked check boxes in an Excel spreadsheet?
 

just to follow up
i've inserted 5 radio buttons into a sheet and if you create a cell
link to a cell on a spare sheet it will return the button number which
if you do it it the same order will correspond to your labels for your
scale 1 to 5.
to insert buttons
go to view toolbars forms
click on option buttons , draw into sheet
right click on control, select format control choose linked cell.


somethinglikeant
wrote:

I would use a seperate worksheet to link the checkboxes to.
If a check box is checked the cell will display true.
Then if you set these up with a nice structure
you can use formulas linked to these cells to formulate values.

On second thought syou might be better with (radio) option buttons as
you will only require one of the five to be selected.
checkboxes allow for upto 5 to be selected.

let me know if you want me to publish an example

somethinglikeant




acpharmd wrote:

I want to create a user-friendly grade sheet for an exercise within a course.
Each of 4 days of student work is considered separately for this score and
all days are rated on a Likert scale. The check boxes seem appealing as an
option to make this form as simple as possible for the faculty so that the
scoring methods will be as consistent as possible from one member of the
teaching team to another - but I cannot figure out how to make these work
with my formulas.

Any ideas?