Others

How to Fix Microsoft Project Resource Costs Not Rolling Up Correctly

Adam Davis Sep 30, 2026 868 views

Question details

The user needs to fix an issue where resource costs in a shared-resource master project are only calculating from the first subtask and failing to roll up from subsequent subtasks.

How to Fix Microsoft Project Resource Costs Not Rolling Up Correctly

Product: Microsoft Project
Device & OS: not provided
Scenario: Tracking and rolling up resource costs across multiple subtasks within a shared-resource master project.
Observed behavior: Resource names appear correctly on multiple subtasks, but the resource costs roll up only from the first subtask, ignoring costs from the rest.

Before you start

Before making changes to your assignments, save a backup copy of your master project and ensure that your shared resource pool file is properly linked and accessible.

Solution 1Recommended

Verify Standard Rates and Cost-Rate Tables

Ensure that every assigned resource has a defined standard rate in the Resource Sheet and that the correct cost-rate table is applied.

Microsoft Project calculates task costs based on the assigned resource's standard rate multiplied by the work hours. If the standard rate is missing or an empty cost-rate table is selected for subsequent subtasks, the rolled-up cost will be zero.

Open the Resource Sheet

Go to the View tab on the ribbon and select 'Resource Sheet' to view all resources in your project.

Check Standard Rates

Locate the resources assigned to the affected subtasks and verify that a valid monetary value is entered in the 'Std. Rate' column.

Verify Assignment Cost-Rate Tables

Switch to the Task Usage view, double-click the assigned resource under the affected subtask to open the Assignment Information dialog, and ensure the correct 'Cost rate table' (usually Table A) is selected.

Verify Standard Rates and Cost-Rate Tables

About Cost-Rate Tables: MS Project allows up to five different pay rates (Tables A-E) for a single resource. Ensure that the table applied to the failing subtasks matches the successful first subtask.

Solution 2

Remove and Reassign Resources

Resetting the resource assignments can resolve issues caused by corrupted task linkages, overallocation, or incorrect task types.

Solution 3

Force Project Recalculation and Update Software

Manually trigger the cost calculation engine and ensure your software is up to date to rule out known application bugs.

Free Microsoft Office alternative

Manage Project Data Seamlessly with WPS Office

If you need a simpler way to track project budgets, timelines, and resource costs without complex software configurations, WPS Spreadsheet provides a highly compatible and user-friendly alternative. Enjoy a free, lightweight suite perfect for everyday project management.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open a Project Template: Launch WPS Spreadsheet, navigate to the Template library, and search for 'Project Budget' or 'Gantt Chart'.
3. Track Resource Costs: Input your resource rates and subtask durations to easily calculate and roll up project costs.

Free and lightweight Microsoft Office alternativeHighly compatible with Microsoft Excel (.xlsx) formatsTrack resource costs and project budgets easily using built-in spreadsheet templatesFamiliar user interface requires no learning curveSeamlessly migrate your exported project data into spreadsheets

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Microsoft Project resource costs showing as $0?

This usually occurs when the assigned resource does not have a standard rate defined in the Resource Sheet, or if the task has zero hours of actual or remaining work scheduled.

How do I force Microsoft Project to recalculate costs?

You can force a manual recalculation by navigating to the Project tab on the ribbon and clicking 'Calculate Project', or by pressing the F9 key on your keyboard.

Can I use different billing rates for the same resource in MS Project?

Yes, Microsoft Project uses Cost Rate Tables (A through E). You can set up to five different rates for a single resource in the Resource Information dialog and apply the specific table needed for individual assignments.

Why is my resource showing as overallocated on subtasks?

A resource becomes overallocated when assigned to work more hours than their maximum available units allow during a specific time period. You can resolve this by adjusting the Max Units in the Resource Sheet or leveling the resource.

Office Quick Solutions