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

Creating a Search using a combo box and then creating a report. 4
Clearing combo boxes and a text box 2
Populate a table based on check box status 2
Master the Checkboxes 0
How to disable synchronization of text boxes. 0
Remove checked items from To Do lists 0
MS Project Import Error Row 1 Column 5 2
Sum of check boxes that have been checked 2

Top