Count # of Parent Rows in a Sheet

Sam C

This seems like such an elementary question but I keep going around and around on this and I can't find what I'm doing wrong. I'm trying to count the number of parent rows in the sheet (each parent row represents an "Employee Name"); I want to include this count in the sheet summary but I can't seem to figure it out. This is what I'm using:

=COUNT(PARENT([Employee Name]))

Andy S.

The workaround I have used is to create a helper column to count ancestors. You could also choose to count descendants instead.

=count(ancestors([Employee Name]@row)

Make it column formula. Then in your sheet summary:

=countif([Ancestors]:[Ancestors], = 0)

Hope this helps

Andy S.

The workaround I have used is to create a helper column to count ancestors. You could also choose to count descendants instead.

=count(ancestors([Employee Name]@row)

Make it column formula. Then in your sheet summary:

=countif([Ancestors]:[Ancestors], = 0)

Hope this helps