How to set or calculate total % completion of tasks in parent row

Shaza

How do I set or calculate total % completion of tasks in the parent row (based on all children tasks below). I have several parent rows in this project plan.

Then how do I create in summary sheet- Formula to calculate the % completion of all tasks in both parent and children rows.

Alwyn

Hi Shaza

1. Highlight the Completion % column.
2. Click on the 3 dots to open the CluCmick on the 3 dots to open the Coln Menu

Paul Newcome

If you are not using dependencies, you would use:

=AVG(CHILDREN())

in the parent rows.

In the sheet summary field, you would use a direct reference to the topmost cell in the column.

=[Completion %]1