Count number of unchecked boxes

brandon.elmer

To count the number of unchecked boxes I'm using the formula:  =COUNTIF([% Complete]3:[% Complete]60, 0).  The issue is that it is also counting blank rows.  How do I get it to only count actual blank checkboxes? 

claytonrlewis

My personal workaround was to create another checkbox column called "Header" and check that box if a row is header type row or maybe a divider. Then I hide that column.

Then using COUNTIFS to look at the header column and the % column

=COUNTIFS([% Complete]3:[% Complete]60, 0, Header3:Header60,0)

Maybe there is an easier way but that's the way I've been doing it.