Sum of checked boxes in Excel 03
elfuerte
-
Patrice33740 Posted messages 8400 Registration date Status Membre Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Membre 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
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 réponses
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?
*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?
