Count the number of projects done for a client without sub projects
I'm trying to count the number of projects completed for a client. I've changed the client name to Apples for confidentiality purposes. I want to count the number of projects done for Apples, without including the indented rows. Screenshot below:
I have tried the following formula: =COUNTIF(DESCENDANTS(Client:Client), "Apples"), however, the result comes back as 7 rather than 5. Any solutions?
Help Article Resources
Check out the Formula Handbook template!