Sum Only Checked Checkboxes
 

I want to create a column of checkboxes that connect with another column. I
want to sum only the checked boxes that connect with the data in the other
column.

Example:
Have "Total Amount" data in Column C. Want to create checkboxes in Column B.
Then want to add the checked boxes related to the specific data in Column C.

Cell Values C7 and C9 are checked in check boxes in B7 and B9. Cell Values
C8 and C10 are not checked in check boxes B8 and B10. How can I quickly add
only those checked boxes (B7 and B9) that relate to values in C7 and C9?

Many thanks in advance for any help.

Sum Only Checked Checkboxes
 

You have to link the checkbox to a cell. This linked cell will show whether
the checkbox is checked or not checked. TRUE = checked, FALSE = not checked.
Then you can do a simple SUMIF:

Checkboxes in the range B:7:B15. Linked cells for each corresponding
checkbox A7:A15.

=SUMIF(A7:A15,TRUE,C7:C15)

You can link the the checkboxes to the actual cells they're "in". Just set
the font color of those cells to be the same as the background color and you
won't see the TRUE or FALSE.

Biff

"Beamers" wrote in message
...
I want to create a column of checkboxes that connect with another column. I
want to sum only the checked boxes that connect with the data in the other
column.

Example:
Have "Total Amount" data in Column C. Want to create checkboxes in Column
B.
Then want to add the checked boxes related to the specific data in Column
C.

Cell Values C7 and C9 are checked in check boxes in B7 and B9. Cell
Values
C8 and C10 are not checked in check boxes B8 and B10. How can I quickly
add
only those checked boxes (B7 and B9) that relate to values in C7 and C9?

Many thanks in advance for any help.

Sum Only Checked Checkboxes
 

"Beamers" wrote:

I want to create a column of checkboxes that connect with another column. I
want to sum only the checked boxes that connect with the data in the other
column.

Example:
Have "Total Amount" data in Column C. Want to create checkboxes in Column B.
Then want to add the checked boxes related to the specific data in Column C.

Cell Values C7 and C9 are checked in check boxes in B7 and B9. Cell Values
C8 and C10 are not checked in check boxes B8 and B10. How can I quickly add
only those checked boxes (B7 and B9) that relate to values in C7 and C9?

Beamers
You need to link each checkbox to a helper cell. Right-click each checkbox,
choose Format, Control and set the link for the box in b7 to d7 if this
column is blank.

When the checkbox is ticked d7 contains the value TRUE. Then you can use the
formula =SUMPRODUCT(--(D2:D13=TRUE)*(B2:B13))

I don't know how to easily link each cell to each checkbox.

Regards
eter

Sum Only Checked Checkboxes
 

The easiest way would be to select (select, not check. May be done with the
"select" tool (white arrow) in the "Drawing" menu OR by clicking on the box
with the right mouse button and then pressing "ESC") the checkbox you want
and then type in the referenced cell in the formula bar (e.g."=A7").

I don't know any way to do it with a lot of checkboxes in one shot. I guess
there's not any method.

Regards!

"PeterAtherton" wrote:
I don't know how to easily link each cell to each checkbox.