View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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