Function

ejacksonBPT

Hello, can someone tell me who to write the function to calculate the numbers in each of the highlighted cells?

Dan Beres

Hi @ejacksonBPT

There are a few ways to go about this. The most straightforward way is to use =AVG([% Complete]<insert row numbers>).

If you are using a Project Sheet (started by clicking on the gear in the top right and designating columns in the Dependency settings), you can use the hierarchy in your WBS to give you a rough idea. The parent tasks won't inherent any % until all the child tasks are at 100% which can be confusing for getting an idea of progress/baselining.

Using the AVG formula can end up being a headache as WBS/Task lists get larger and more complex because you need to ensure that the formula is catching every task. I have an example below showing the differences, with the % Complete being from the Dependency Settings, and the % Complete AVG using:

=AVG([% Complete AVG]2:[% Complete AVG]6) - Yellow

=AVG([% Complete AVG]8) - Purple

=AVG([% Complete AVG]1, [% Complete AVG]7) - Orange

Let me know if you have any questions or would like me to elaborate on anything!

ejacksonBPT

Is there a way to divide the total number of tasks, 6 (which includes A.1, A.1.1, A.2, A.2.1, A.2.2, B.1) by the total number of 100% completed tasks, 3 (which are A.1, A.1.1, A.2.1)