[SOLVED] Progress tracking i percent

Hello, i am making a task list for my team at work, built in an hierarchy so that i can track total progress pr area and progress pr single task.

I have the status and progress percentages for each task allready, but i am struggelig to make it sum up the progress for each area.
So in the attached excel file you can see that the first area from row 3 to 10 should be summarized in D2 with the overall progress, based on the data there now (1 task 100%, 7 tasks 0%) it should say 12,5%, when one more task is 100% it should say 25% and so on.

For the rows 12 and 13 where there is one out of two tasks completed to 50% it should track overall progress as 25% completed.

Hope the explenation was not to confusing. Anyone able to help?

Hello paulsen and Welcome to Excel Forum.
As to cell D2 you could use: =AVERAGE(D3:D10)
Format the cell to Percentage and select the number of decimal places that you would like to have displayed.
Let us know if you have any questions.

Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.