Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2018, 02:35 PM
Learners Permit Learners Permit is offline Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value. Windows 10 Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value. Office 2016
Novice
Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value.
 
Join Date: Jun 2018
Location: Tucson, AZ
Posts: 3
Learners Permit is on a distinguished road
Default Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value.

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
Attached Files
File Type: docx Perf Rvw Test.docx (30.0 KB, 9 views)
Reply With Quote
  #2  
Old 07-02-2018, 03:14 PM
macropod's Avatar
macropod macropod is offline Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value. Windows 7 64bit Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-16-2018, 07:56 PM
Learners Permit Learners Permit is offline Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value. Windows 10 Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value. Office 2016
Novice
Need to tally check boxes (labeled 1-5) on performance review to get total score based on box value.
 
Join Date: Jun 2018
Location: Tucson, AZ
Posts: 3
Learners Permit is on a distinguished road
Default

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
Total Checked FF Check Boxes CarlCR Word Tables 2 07-13-2016 12:01 PM
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
how to show total of check boxes checked worder Word 16 03-10-2014 05:07 PM
Word2010 check boxes and plain text content control boxes in same table fcsungard Word 5 06-01-2012 01:16 AM
Problem with Developer Form -- Check Boxes and Text Boxes PCC Word 1 05-16-2009 05:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft