Adding Check Boxes

[Mike R]

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.

[Biff]

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.
>
>.
>

[Mike R]

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.
> >
> >.
> >
>