In Excel, how to count a list of check boxes some are checked?

I have a list of names/accounts, in front of each there's a check-box which
tells if the account was completed or not (checked or cleared - false or
true). How can I count the total of checked and/or unchecked check boxes?
Thank you

Link the checkboxes to cells, and then just sum those values.

If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
checkboxes set a value of 1 or 0.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" M. wrote in message
...
I have a list of names/accounts, in front of each there's a check-box
which
tells if the account was completed or not (checked or cleared - false or
true). How can I count the total of checked and/or unchecked check boxes?
Thank you

Thanks for answering, I had to put many check-boxes in the same sheet, so I
just copied and pasted the first one I created, so they're all linked to the
same cell, that's actually the issue I'm having, to link each check box to a
different cell..."
Thanks a lot

"Bob Phillips" wrote:

Link the checkboxes to cells, and then just sum those values.

If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
checkboxes set a value of 1 or 0.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" M. wrote in message
...
I have a list of names/accounts, in front of each there's a check-box
which
tells if the account was completed or not (checked or cleared - false or
true). How can I count the total of checked and/or unchecked check boxes?
Thank you

Control toolbox

"Bob Phillips" wrote:

What sort of checkboxes, forms or control toolbox?


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" wrote in message
...
Thanks for answering, I had to put many check-boxes in the same sheet, so
I
just copied and pasted the first one I created, so they're all linked to
the
same cell, that's actually the issue I'm having, to link each check box to
a
different cell..."
Thanks a lot

"Bob Phillips" wrote:

Link the checkboxes to cells, and then just sum those values.

If it is Forms checkboxes set a value of TRUE or FALSE, control toolbox
checkboxes set a value of 1 or 0.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" M. wrote in message
...
I have a list of names/accounts, in front of each there's a check-box
which
tells if the account was completed or not (checked or cleared - false
or
true). How can I count the total of checked and/or unchecked check
boxes?
Thank you

This code will link all your CBs to cells in column M

Sub LinkCBs()
Dim i As Long
Dim obj As OLEObject

With ActiveSheet
For Each obj In .OLEObjects
If TypeName(obj.Object) = "CheckBox" Then
i = i + 1
obj.LinkedCell = "M" & i
End If
Next obj
End With
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" wrote in message
...
Control toolbox

"Bob Phillips" wrote:

What sort of checkboxes, forms or control toolbox?


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" wrote in message
...
Thanks for answering, I had to put many check-boxes in the same sheet,
so
I
just copied and pasted the first one I created, so they're all linked
to
the
same cell, that's actually the issue I'm having, to link each check
box to
a
different cell..."
Thanks a lot

"Bob Phillips" wrote:

Link the checkboxes to cells, and then just sum those values.

If it is Forms checkboxes set a value of TRUE or FALSE, control
toolbox
checkboxes set a value of 1 or 0.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" M. wrote in message
...
I have a list of names/accounts, in front of each there's a
check-box
which
tells if the account was completed or not (checked or cleared -
false
or
true). How can I count the total of checked and/or unchecked check
boxes?
Thank you

Hi Bob; thanks a lot it's working, now I can count how many false and how
many true for my checkboxes, I just didn't include the first line in my new
sub_code:"Sub LinkCBs()" now it works..thanks again

"Bob Phillips" wrote:

This code will link all your CBs to cells in column M

Sub LinkCBs()
Dim i As Long
Dim obj As OLEObject

With ActiveSheet
For Each obj In .OLEObjects
If TypeName(obj.Object) = "CheckBox" Then
i = i + 1
obj.LinkedCell = "M" & i
End If
Next obj
End With
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" wrote in message
...
Control toolbox

"Bob Phillips" wrote:

What sort of checkboxes, forms or control toolbox?


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" wrote in message
...
Thanks for answering, I had to put many check-boxes in the same sheet,
so
I
just copied and pasted the first one I created, so they're all linked
to
the
same cell, that's actually the issue I'm having, to link each check
box to
a
different cell..."
Thanks a lot

"Bob Phillips" wrote:

Link the checkboxes to cells, and then just sum those values.

If it is Forms checkboxes set a value of TRUE or FALSE, control
toolbox
checkboxes set a value of 1 or 0.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"M. Zak" M. wrote in message
...
I have a list of names/accounts, in front of each there's a
check-box
which
tells if the account was completed or not (checked or cleared -
false
or
true). How can I count the total of checked and/or unchecked check
boxes?
Thank you

how about using countif

Ashwini

"M. Zak" wrote:

I have a list of names/accounts, in front of each there's a check-box which
tells if the account was completed or not (checked or cleared - false or
true). How can I count the total of checked and/or unchecked check boxes?
Thank you