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.

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.

.

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.

.