Counting nonchecked checkboxes
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 Article Resources
Check out the Formula Handbook template!