Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value.

[Learners Permit]

Hello! I have a table in a Microsoft Office Word 365 Business document. This document is an annual performance review with competencies on the left and a section to the far right which houses check boxes to be used to rate an employee's performance. Each of the five check boxes lives in a seperate cell with their value typed underneath, values are 1 - 5. Each competency has its own set of check boxes, all valued 1 - 5.

I would like to have the checked check boxes tally, based on their value, and provide a total for each section. Then on the last page I would like to have a total consisting of the totals from each section.

I attached a copy of what I have so far...help would be greatly appreciated!

Thanks!


Ryan

[macropod]

Personally, I wouldn't use formfield checkboxes for this for two reasons:
1. You can't make them mututally exclusive; and
2. You can't tally their results,
without recourse to a macro. I would use dropdown formfields instead. See, for example: https://www.msofficeforums.com/word/...html#post74823

[Learners Permit]

Thanks. I took your advice and saved myself a ton of time and effort yet still obtained the same result.