COUNTIF with Parent rows only, exclude children
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.
Help Article Resources
Check out the Formula Handbook template!