sum of check boxes that have been checked

  • Thread starter Thread starter confused??
  • Start date Start date
C

confused??

I have a list of check boxes and I would like to add how many check boxes
have been checked. I would like to put the total in a different colunm. All
of the check boxes are linked to the corresponding cell.

How will i do this?
 
hi, !
I have a list of check boxes and I would like to add how many check boxes have been checked.
I would like to put the total in a different colunm.
All of the check boxes are linked to the corresponding cell.

How will i do this?
Click to expand...

=sumproduct(--a2:a8)

=sumif(a2:a8,true)

hth,
hector.
 
What happened to your previous post...responses from Biff and myself..

=COUNTIF(A1:A10,1)
or
=COUNTIF(A1:A10,TRUE)


If this post helps click Yes
 
Back
Top