View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beamers Beamers is offline
external usenet poster
 
Posts: 4
Default 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.