View original (French)

Sum of checked boxes in Excel 03

elfuerte -  
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   -
Hello,

I'm stuck on something quite simple. I have 4 columns in Excel 2003 and each cell contains a checkbox. I want to total the number of checked boxes for each column! How do I do that?

Urgent work to submit to my boss!

I await your responses :D

Elfuerte

Configuration: Windows XP / Internet Explorer 8.0

8 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    *I think this is about checkboxes and not cells, therefore, COUNTIF or SUMIF can only be applied from an intermediate column
    Example below to be adapted:
    in column A, a series of checkboxes with a corresponding amount in each cell A that should be summed only if the checkbox is checked
    For each checkbox:
    right-click on the box / Control Format / Control tab
    and linked cell:
    enter B1 for checkbox in cell A1, B2 for checkbox in cell A2, etc....
    when the checkbox is checked, the linked cell shows TRUE or FALSE

    Then, to sum, in a cell outside the range:

    =SUMIF(B:B,TRUE,A:A)

    and to count the number of values considered:
    =COUNTIF(B:B,TRUE)

    unless I misunderstood the topic

    best regards

    Let’s ask ourselves if we are not alone in understanding what is being explained?
    5