| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to count the number of boxes checked
If the checkbox is from the control toolbox; in design mode right click the
checkbox properties and set the linked cell of each check boxe to its cells and try the formula in the total cell =COUNTIF(F8:F27,TRUE) If this post helps click Yes --------------- Jacob Skaria "Annie" wrote: Hello, In Excel a form was created where check boxes were created within cells F8:F27. I would like to add a formula at the bottom of the form to count the number of boxes that are checked. I've tried using the countif formula, but I don't know how to tell it to count the boxes with a check mark Can anyone help me, please? -- Thanks, Annie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of check boxes that have been checked | Excel Worksheet Functions | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Worksheet Functions | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Discussion (Misc queries) | |||
| In Excel, how to count a list of check boxes some are checked? | Excel Worksheet Functions | |||
| I want to be able to count the number of checked boxes in a form? | Excel Worksheet Functions | |||
Hybrid Mode
