Countif of children cells

Chiara15

Hello everyone! I got stuck on a formula that I need as KPI to monitor a project. I need a formula similar to the one that appears by default and that shows the percentage of completed task per macro level. In my case, I need it also for the other activity statuses, such as in progress and not started, so that in the end it will show the percentage of tasks with the specified status for each level of the project. Can anyone help with that? Is it possible to do it?

Paul Newcome

Are you able to provide more specifics? What formula are you referring to that appears by default? Are you able to provide some screenshots of the source data as well as some manually entered data that reflects what you would like the outcome of the formula to be?