Formula for Microsoft Project % Complete Rollup

jack nolan 1 Reputation point
2022-01-25T15:17:32.333+00:00

I am trying to figure out the formula used for Microsoft Project % Complete rollup so that I can use Microsoft Project in an Excel version. I know that the rollup is not just the average of the tasks. A forum I found online said that:
% Complete = (Actual Duration/Duration) x 100
with Actual Duration = Duration x Percent Complete

What formula should I put in the highlighted box to get the rollup percentage of 79%?

168404-excel-vs-project.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,640 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 8,991 Reputation points
    2022-01-25T17:08:43.863+00:00

    Hi @jack nolan

    168385-excelpercentcomplete.png

    in B2: =SUMPRODUCT(D3:D8,B3:B8) / SUM(D3:D8) and format the cell as %age