"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