how do you count checkboxes in excel2003

P

plhanlon

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

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
 
Top