| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding up checked boxes in cells in a row
If you ONLY allow the cell to be either the check character or
blank, you could test for the blank COUNT and subtract from the total check box COUNT. The answer would yield the number of checked boxes. So, you count the blanks instead. In this case I'd probably count the checks so I don't have to include the extra math calcs.<g =COUNTA(#:#) ... # is the row[s] to evaluate. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Count Formual with checked boxes | 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 | |||
| How do I total a series of checked boxes? | Excel Worksheet Functions | |||
| How do I restrict only 1 of 2 check boxes be checked? | Excel Discussion (Misc queries) | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
