Why Microsoft Project Summary Task Percentage Appears Incorrect
Question details
Users notice that the summary task completion percentage in Microsoft Project appears disproportionately high or incorrect compared to the progress of individual subtasks.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Reviewing project progress and checking summary task completion percentages.
- Observed behavior
- The summary task shows a high percentage complete even when underlying subtasks have little to no recorded progress.
Ensure that you have entered the actual durations for all subtasks correctly, as this data directly feeds into the summary calculation.
Understand Microsoft Project's Duration-Based Calculation
Learn how Microsoft Project calculates summary percentages so you can interpret the data correctly and avoid manual overwrites.
Microsoft Project does not calculate summary task completion by simply averaging the completion percentages of its subtasks. Instead, the calculation is strictly based on duration.
The formula used by the software divides the sum of all subtask actual durations by the sum of all subtask total durations. Because this is based on elapsed time, the passage of time does not necessarily mean physical work has been accomplished.
Check the 'Actual Duration' column for each subtask to see the exact time logged as elapsed.
Verify the planned 'Duration' column for these tasks to understand the total time allocated.
Calculate the expected percentage using this formula: (Sum of Actual Durations / Sum of Total Durations) * 100. This will match the summary task percentage displayed.

Manage Projects Efficiently with WPS Office
If you find Microsoft Project overly complex for simple task tracking, consider using WPS Spreadsheet. It offers a free, lightweight, and highly customizable way to manage project timelines, calculate progress with custom formulas, and collaborate with your team without a steep learning curve.
- 1. Download and Install WPS Office: Get WPS Office for free from the official website and launch WPS Spreadsheet.
- 2. Choose a Project Template: Navigate to the template library and search for 'Project Management' or 'Gantt Chart' to find a ready-to-use tracker.
- 3. Customize Progress Tracking: Input your tasks and durations. You can use simple AVERAGE formulas to track true completion percentages exactly how you prefer.

Frequently Asked Questions
Can I manually override the summary task percentage in Microsoft Project?
It is highly recommended not to manually overwrite summary task percentages. The software automatically calculates this based on the actual and total durations of the subtasks. Manually altering it can cause inconsistencies in your project schedule.
Why does my project summary task show 50% complete when no actual work is done?
This happens if you have logged actual duration (elapsed time) on subtasks. Microsoft Project calculates the '% Complete' field based on time passed relative to total scheduled duration, not the physical work completed.
How can I track physical work completion instead of duration completion?
To track actual effort rather than elapsed time, you should use the '% Work Complete' field instead of '% Complete'. '% Work Complete' is calculated based on actual work hours logged versus total planned work hours.




