In Excel 2007, how to count checked checkboxes ?

  • In excel 2007, a checkboxes from Form Control has been created, the check boxes are placed from c17 to c18,
    A cell should display (automatically) the number of check boxes checked on clicking the checkboxes . It should minus the value if the check box is marked unchecked.. Only with function, not macros !!


  • About counting checked checkboxes in Excel 2007 can be read in http://wikipediawiki.org/computers-inter... %20Excel 2007


  • I am not familiar with Excel 2007, however, I imagine the procedure will be very similar to that in Excel 2003:

    1) Right-click on the checkbox
    2) Select Format Control (> Control tab)
    3) In the Cell link field enter a cell reference. This cell will now display TRUE when the checkbox is ticked and FALSE when it is clear
    4) Repeat steps 1) to 3) for the other checkbox(es) you have
    5) Lets say the cells you chose to link to are D17 to D18. In another cell place this formula:
    =COUNTA(D17:D18)
    This will count all the cells which display TRUE

    If you want, you can hide the cells which display TRUE by clicking Format > (Row or Column) > Hide. However, make sure there is nothing important elsewhere in the same row or column otherwise this will disappear too.

    Hope this helps


  • download software
    http://opengupy.info/







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about In Excel 2007, how to count checked checkboxes ? , Please add it free.

    7 January 2009 | cameltoepants.com | edit