I need the formula for counting the checkboxes in a column.
The whole column?
=COUNTIF([ColumnNameHere]:{ColumnNameHere],1)
Craig
Its comog up unparseable. Did find this formula ="" + COUNTIF(CHILDREN(), 1) to add up the booleans. Now I need these numbers to make a total at the top.
Oops.
=COUNTIF([ColumnNameHere]:[ColumnNameHere],1)
I'm not sure how that curly brace got there.
CHILDREN will only work the rows that are indented. If you have more than one section (parent row) then it won't grab the whole column, only parts - which is also useful in some cases.
By adding the "" you have changed the count (a number) to text and may have difficulty doing more math on them if you need to.
