Formula help for project roll up

Hello,
I'm struggling to come up with the correct formula to use. I have a sheet with several different project numbers and also use the same project numbers. There is a planned, in progress, and completed status. There are parent and children rows with each project #. I'm only concerned with coming up with the sum of each status one one project # that is used 35 times across the same sheet. I created a report but since there are children it's only counting the project status as a whole instead of by the status type. I then decided to create a separate sheet to use a formula to roll up only that project # by incorporating the status, but I'm struggling on what formula to use. I would like to have this show in the report already built and also on a graphy in a dashboard. Any advice would be appreciated!
Example for the columns:
Thank you!
Answers
-
Are you able to provide the expected output for the above screenshot? I'm not sure I follow exactly what you are wanting to accomplish.
Help Article Resources
Categories
Check out the Formula Handbook template!