View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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.

.