COUNTIF with Parent rows only, exclude children

cody

I want to create a COUNTIF function that will count only the Parent row of a status column in a project tracking sheet. This is to create a metric sheet that will show all project statuses by each project manager's sheet. There is a status column using Green/Yellow/Red/Blue identifiers, and children rows need to include the status column GYRB. For the metric sheet, I need all children rows to be excluded. 

 

The metric sheet is so I can track all parent projects without the children rows inflating the data.

Paul Newcome

You can create a helper column (called "Helper" for this example). You can then use a basic COUNT function

 

=COUNT(CHILDREN([Task Column Name]@row))

 

You can then pull all rows that do NOT have a zero in the Helper column meaning that the row has at least one child row (making it a parent row).

 

You could also make the Helper column a checkbox type and use

 

=IF(COUNT(CHILDREN([Task Column Name]@row)) > 0, 1)

 

That would check the box for all parent rows which makes pulling all parent rows that much easier.