sum of check boxes that have been checked
 

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?

sum of check boxes that have been checked
 

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?

=sumproduct(--a2:a8)

=sumif(a2:a8,true)

hth,
hector.

sum of check boxes that have been checked
 

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
---------------
Jacob Skaria


"confused??" wrote:

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?

sum of check boxes that have been checked
 

Sorry... I'm new at this and the link on the notification email i received
didn't work, it took me a while to find this post but i'm glad i did because
that worked beautifully! Thank you very much!

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"confused??" wrote:

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?