Counting nonchecked checkboxes

Stacy M

I have read a few forums and cannot get the right formula to work to count the number of unchecked boxes in a column that has checkboxes and "-" (for non-applicable). I can count checked boxes and when I try to count unchecked it counts the "-" fields, too.

=COUNTIF(ISBOOLEAN(1), "Cell contains a boolean value", "cell doesn't contain a boolean value")

Help, please?

matthewsmart

SO using the sheet summary I created a field to add the following formula. However you could effectively add it to any cell in the sheet itself.

=COUNTIF([Column5]1:[Column5]15, <>1)

Column5 being the checkbox columns

Example.png