| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Check box totall
I would like excel to total all of the checked boxes in a column, ie how many
boxes have been checked in that column. How do I do that |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Check box totall
In properties for the checkboxes, set a linked cell to each check box. (Can
be anywhere out of the way on the worksheet). The cells will show true or false depending on whether the box it is checked or unchecked. Then in another cell insert the following formula:- =COUNTIF(D1:D4,TRUE) The above is where cells D1 to D4 are the linked cells for 4 check boxes. -- Regards, OssieMac "J" wrote: I would like excel to total all of the checked boxes in a column, ie how many boxes have been checked in that column. How do I do that |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) | |||
Linear Mode
