**Help HR Has Me Assigning Values To Checkboxes And Trying To Add Them**

[Ryan]

Everyone,


The HR Director has tasked me with taking his review document that
has various tables, checkboxes with in these tables, and adds a value
to each check box. So when a user click it the value will then be
added to that box, after that I need to look in each column and add
the values together from what boxes have checks marked in them. Is
there any way I can get this accomplished, I am a network guy not a
Word guru... Please help....

 

[Martha]

(e-mail address removed) (Ryan) wrote ...

The HR Director has tasked me with taking his review document that
has various tables, checkboxes with in these tables, and adds a value
to each check box. So when a user click it the value will then be
added to that box, after that I need to look in each column and add
the values together from what boxes have checks marked in them. Is
there any way I can get this accomplished, I am a network guy not a
Word guru... Please help....

<insert puzzled face here> He wants you to do this in *Word*? Even if
there were a way to force Word to do something like this (which there
isn't, at least not without a LOT of VBA), it would be entirely the
wrong tool.

You could do something like this in Excel by linking checkboxes to
cells (which will give a 'true' or 'false' value in the linked cell,
depending on whether the checkbox is selected), putting the value for
each checkbox next to the linked cell, and using the SumIf function to
add up the values. The auxiliary cells (with the true/false and the
value) could be put in hidden columns, leaving only the sum showing
for the user. You could also protect the worksheet, so users can't
change the formula or unhide the columns.

For example, if your linked cells are E1:E15, put the values in
F1:F15. The conditional sum formula is then:
=SumIf(E1:E15,True,F1:F15)