| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding Check Boxes
xl2000
I have some check boxes that I have put in via the forms tool bar. I have linked them to the appropriate cells and get a true if checked and a false if not checked. How do I add the number of check boxes that are checked? Thanks for all the help!! Mike R. |
|
#2
|
|||
|
|||
|
Hi!
Just use a Countif on the range of linked cells: =3DCOUNTIF(B1:B10,TRUE) Biff -----Original Message----- xl2000 =20 I have some check boxes that I have put in via the =E2? oforms=E2?=9D tool bar. I have=20 linked them to the appropriate cells and get a =E2?otrue=E2?=9D=20 if checked and a=20 =E2?ofalse=E2?=9D if not checked. How do I add the number of=20 check boxes that are=20 checked? =20 Thanks for all the help!! Mike R. . |
|
#3
|
|||
|
|||
|
Thanks Biff
Worked like you said it would!!! (And it just amazes me)!!! Mike R. "Biff" wrote: Hi! Just use a Countif on the range of linked cells: =COUNTIF(B1:B10,TRUE) Biff -----Original Message----- xl2000 I have some check boxes that I have put in via the â? oformsâ? tool bar. I have linked them to the appropriate cells and get a â?otrueâ? if checked and a â?ofalseâ? if not checked. How do I add the number of check boxes that are checked? Thanks for all the help!! Mike R. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filters and Check Boxes | Excel Worksheet Functions | |||
| Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
| Do you have instructions for making check boxes? | Excel Worksheet Functions | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
| how to incert multiple check boxes in excel | Excel Worksheet Functions | |||
Linear Mode
