Creating a formula to calculate percent from the parent rows
I am trying to create a formula for a cell where it collects the percentage of all the % values in the parent rows below it. Not only the current parent rows, but also any new ones that are added. The parent rows are currently averaging the percent in the sub rows below it. In this case, I want the total percent to be in the purple row. Thank you!
Help Article Resources
Check out the Formula Handbook template!