how do you count checkboxes in excel2003

[Guest]

I am trying to add up the number of checked checkboxes in a column. Is there
a formula that will look at how many are checked vs how many are unchecked?

 

[Biff]

Hi!

Do you have the checkboxes linked to other cells?

If so, then you just need to count the instances of TRUE (for checked) and
FALSE (for unchecked).

For example, the checkboxes are in column A, A1:A10. Each checkbox is linked
to the corresponding cell in column B.

To count the number that are CHECKED:

=COUNTIF(B1:B10,TRUE)

To count the number that are UNCHECKED:

=COUNTIF(B1:B10,FALSE)

Biff