| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
adding up checked boxes in cells in a row
don't know how to do it. when i copied row above, it mimics that row. each row needs to be individual.
please break answer down. I have basic training in excel. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding up checked boxes in cells in a row
What do you consider as a "checked box"?
If you "copy" something I would expect it to mimic the original. That is the meaning of "copy". Please try again with your problem description. Gord On Wed, 8 May 2013 17:14:17 +0100, kstivers wrote: don't know how to do it. when i copied row above, it mimics that row. each row needs to be individual. please break answer down. I have basic training in excel. thanks |
|
#3
|
|||
|
|||
|
Quote:
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adding up checked boxes in cells in a row
On Wed, 8 May 2013 21:14:21 +0100, kstivers
wrote: 'Gord Dibben[_2_ Wrote: ;1611702']What do you consider as a "checked box"? If you "copy" something I would expect it to mimic the original. That is the meaning of "copy". Please try again with your problem description. Gord On Wed, 8 May 2013 17:14:17 +0100, kstivers wrote: - don't know how to do it. when i copied row above, it mimics that row. each row needs to be individual. please break answer down. I have basic training in excel. thanks- a box to check mark or not- as in row b2 checked, row b3 checked, row b4 not checked, how do you make that... and then in the end row of cells- the total of checked boxes is added in b 24. 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. |
|
#5
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) | |||
Linear Mode
