sum of check boxes that have been checked

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?
 
H

Héctor Miguel

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

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of check boxes that have been checked 2
How can I sum up several check boxes conditioned by a combo box? 4
Sum Only Checked Checkboxes 3
Check Boxes 1
Check Boxes 2
link check boxes in multiple cells 1
check box 1
Check boxes 2

Top