Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkboxes vs. Option Buttons | Excel Discussion (Misc queries) | |||
How do I delete checkboxes from rows I deleted in a macro? | Excel Discussion (Misc queries) | |||
My checkboxes will not stay checked. | Excel Discussion (Misc queries) | |||
Copy checkboxes to another sheet | Excel Discussion (Misc queries) | |||
Counting the number of checkboxes on a spreadsheet | Excel Worksheet Functions |