Show Value Sum of total Parent Rows checked.

Laura

I've researched this and cant find a solution. 

 

How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to do it only for Parent rows.

 

Also, Can I place this formula on the checkbox column (at the very top for a total) and show a value? 

 

Thanks in Advance

Marcus Odum

you can create a checkbox column that validates the parent row:

1. Create a column called vParent (lock it)
2. enter the following formula:
   • =IF(COUNT(CHILDREN()) > 0,1,0)

this will enter a check if the the row has children. Now in your summary cell you can enter 

=COUNTIF(vParent:vParent,1)