Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count if checkbox or radio button is indicated (Excel XP)

    Is it possible to use the countif function to count the number of checkboxes or radio buttons which have been activated? Similar to countif(A1:A10,"x") I would like to have participants indicate their response by clicking in a check box or clicking a radio button rather then entering an 'x'. I am using the forms toolbar as opposed to the control toolbar to create the check boxes or radio buttons.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count if checkbox or radio button is indicated (Excel XP)

    You can set the linked cell for each of the check boxes. The cells will contain TRUE or FALSE depending on whether the check box is ticked. You can then use COUNTIF on the range of linked cells to count the number of TRUE values.

    In a group of radio buttons, only one can be selected, so there is no point in counting the number of selected radio buttons.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Count if checkbox or radio button is indicated (Excel XP)

    You can use a formula and countif TRUE for the cells linked to the checkboxes (if you have cells linked). If you do not have cells linked, it would require coding to check the various checkboxes to get the status.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •