Formula for Microsoft Project % Complete Rollup

jack nolan 1 Reputation point

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%?


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,516 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Lz._ 8,971 Reputation points

    Hi @jack nolan


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