sum of option boxs

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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)
 
Back
Top