| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Count Formual with checked boxes
Hello,
(2nd Posting -- just in case the first request did not Post correctly) I have a form in Excel that has boxes within cells F8:F27. When you click on the box, it inputs a check mark. I would like to use a formula to count all boxes that are checked (actual check mark) Can anyone help me, please? -- Thanks, Annie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Count Formual with checked boxes
Hi,
If the boxes have been created through the option in the Forms menu, then one can supply a cell link cell in the Format control box. The cell link will display as TRUE when the box is checked. Then one can use the =countif(range,true) to count the checked boxes -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Annie" wrote in message ... Hello, (2nd Posting -- just in case the first request did not Post correctly) I have a form in Excel that has boxes within cells F8:F27. When you click on the box, it inputs a check mark. I would like to use a formula to count all boxes that are checked (actual check mark) Can anyone help me, please? -- Thanks, Annie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count the number of boxes checked | Excel Worksheet Functions | |||
| sum of check boxes that have been checked | Excel Discussion (Misc queries) | |||
| Sum of check boxes that have been checked | Excel Worksheet Functions | |||
| 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 | |||
Linear Mode
