Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox sum
Hi,
I need to know how can I make a sum with checkboxes Example: Containers: caxu125414, quanity of pairs: 220 Containers: chjcu25455, quanity of pairs: 5620 And next to the quanity cell, I've a checkbox (True or False) Now, how and which formula can I use to make a sum, when the ckeckbox is at TRUE? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox sum
Hi Fred,
Create a linked cell for the checkbox anywhere on the worksheet and sum the values if the cell is true otherwise put nothing (2 double quotes like this "") in the cell. Example assuming A1 is the linked cell and D2:D4 is the range to sum. =IF(A1=TRUE,SUM(D2:D14),"") If statement which tests for True or False can be shortened to this:- =IF(A1,SUM(D2:D14),"") Regards, OssieMac "Fred's" wrote: Hi, I need to know how can I make a sum with checkboxes Example: Containers: caxu125414, quanity of pairs: 220 Containers: chjcu25455, quanity of pairs: 5620 And next to the quanity cell, I've a checkbox (True or False) Now, how and which formula can I use to make a sum, when the ckeckbox is at TRUE? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox sum
Hi again Fred,
Had another look at this and not sure if I got your meaning correct. If you meant that you want to sum each value that has a checkbox beside it then you need a linked cell beside each value for the associated checkbox. Assuming that the range containing the values is D2:D14 then the linked cells could be C2:C14. The forumla would then be:- =SUMIF(C2:C14,TRUE,D2:D14) The linked cells can be over to the right of your data out of sight just so long as they line up with the range to be summed. Hope one of the answers is what you want. Regards, OssieMac "OssieMac" wrote: Hi Fred, Create a linked cell for the checkbox anywhere on the worksheet and sum the values if the cell is true otherwise put nothing (2 double quotes like this "") in the cell. Example assuming A1 is the linked cell and D2:D4 is the range to sum. =IF(A1=TRUE,SUM(D2:D14),"") If statement which tests for True or False can be shortened to this:- =IF(A1,SUM(D2:D14),"") Regards, OssieMac "Fred's" wrote: Hi, I need to know how can I make a sum with checkboxes Example: Containers: caxu125414, quanity of pairs: 220 Containers: chjcu25455, quanity of pairs: 5620 And next to the quanity cell, I've a checkbox (True or False) Now, how and which formula can I use to make a sum, when the ckeckbox is at TRUE? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
link a checkbox in a sheet to a checkbox on a userform? | Excel Programming | |||
How do I link one checkbox to update another checkbox? | Excel Programming | |||
checkbox on form reset from checkbox on sheet | Excel Programming | |||
Help w/ CheckBox ????? | Excel Programming |