Aggregating Project Costs by Completion Status
As a Project Manager, I oversee multiple projects, each with varying costs and statuses. I need to quickly determine the total cost of all 'Completed' projects to reconcile budgets, or the total cost of 'In Progress' projects to forecast remaining expenditures. Manually filtering and summing is inefficient.
=SUMIF(B2:B6,"Completed",C2:C6) How it works: This formula efficiently scans the 'Status' column (B2:B6) for any project marked as 'Completed'. For each 'Completed' project it finds, it then adds its corresponding 'Cost' from column C (C2:C6) to a running total. This provides an accurate sum of all costs associated with completed projects.
Data Setup
| Project Name | Status | Cost |
|---|---|---|
| Alpha | Completed | 5000 |
| Beta | In Progress | 3000 |
| Gamma | Completed | 7500 |
| Delta | On Hold | 1000 |
| Epsilon | In Progress | 4000 |
Step-by-Step Guide
Identify the range containing the project statuses (e.g., B2:B6).
Specify the desired status as your criterion (e.g., "Completed").
Point to the range containing the project costs to be summed (e.g., C2:C6).
Construct the formula: `=SUMIF(B2:B6,"Completed",C2:C6)`.
Explore More
Assembling Project Task Dependency Chains
A project manager needs to quickly create a visual representation of a sequence of dependent tasks for a project phase. They want to combine the task names into a single, easy-to-read string, separated by an arrow (e.g., ' -> '), to clearly show the workflow and dependencies to team members or stakeholders. Manually typing this out for many tasks is inefficient and prone to errors.
Determine Project Deadline from Start Date
I need to find the exact calendar date for a project deadline that is 45 working days from the start date.
List All Pending Permits
I need to join all 'Permit Types' that have a status of 'Pending' into a single cell for the weekly summary.