Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how to count a list of check boxes some are checked?
I have a list of names/accounts, in front of each there's a check-box which
tells if the account was completed or not (checked or cleared - false or true). How can I count the total of checked and/or unchecked check boxes? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how to count a list of check boxes some are checked?
Link the checkboxes to cells, and then just sum those values.
If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox checkboxes set a value of 1 or 0. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "M. Zak" <M. wrote in message ... I have a list of names/accounts, in front of each there's a check-box which tells if the account was completed or not (checked or cleared - false or true). How can I count the total of checked and/or unchecked check boxes? Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how to count a list of check boxes some are checked?
Thanks for answering, I had to put many check-boxes in the same sheet, so I
just copied and pasted the first one I created, so they're all linked to the same cell, that's actually the issue I'm having, to link each check box to a different cell..." Thanks a lot "Bob Phillips" wrote: Link the checkboxes to cells, and then just sum those values. If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox checkboxes set a value of 1 or 0. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "M. Zak" <M. wrote in message ... I have a list of names/accounts, in front of each there's a check-box which tells if the account was completed or not (checked or cleared - false or true). How can I count the total of checked and/or unchecked check boxes? Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how to count a list of check boxes some are checked?
how about using countif
Ashwini "M. Zak" wrote: I have a list of names/accounts, in front of each there's a check-box which tells if the account was completed or not (checked or cleared - false or true). How can I count the total of checked and/or unchecked check boxes? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Drop Down box or check box data to Excel Database | Excel Discussion (Misc queries) | |||
Strange behavior w/ Text, Button, & Check Boxes | Excel Discussion (Misc queries) | |||
why do check boxes move when printing excel spreadhseets | Excel Discussion (Misc queries) | |||
How do I enter a working check box option in Excel? | Excel Discussion (Misc queries) |