sum of option boxs

D

Dave

i have a list of values with a corresponding checkbox to
select each one. how do i get only whats checked to total
in a cell? thanks
 
F

Felipe I

You can link the checkboxes to a cell and then use that
cell for your calculations:

1. Open the control tool box menu
2. Select design mode
3. Select the check boxes and go to Properties by right
clicking them.
4. Use the LinkedCell property. You can link the check box
to any cell in the worksheet by typing the reference (e.g.
A1)
5. Do this for every check box (note: each checkbox should
be linked to a different cell)

Assuming you linked the checkboxes to cells A1:A10 and you
have the values on cells B1:B10, you can add up the total
by using the following formula:

SUMIF(A1:A10,TRUE,B1:B10)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate a table based on check box status 2
How to make repeating drop-down lists? 2
list or combo box 0
Adding cells until they are greater than a lookup cell and returning a value 1
How to create bulleted to-do list using two styles? 5
Adding a big matrix in Word 2013 5
Word OLE to check spelling in text box 1
Link a text box based on drop down box with four options MS Word 365 0

Top