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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
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 |