Count the number of projects in each stage

TN_RDB2025

Objective: Count the number of projects in each stage

I'm trying to get the count of the different stages of each project from my project sheet to my roll up sheet. Can you advise what should be the correct formula?

Here's the formula I used in my roll up:

=COUNTIFS({Column x}{Project List Range 1})+(Stage:Stage, "Due Diligence")

Below are the Stages from the Project sheet that I want to be referenced into the roll up sheet.

Due Diligence
Entitlements
Arch & MEPS Design
Civil Design
Permitting - Arch & MEPS
Permitting - Civil

Hudson_Miller

@TN_RDB2025 -

Hello -

I think you are overthinking the formula a bit. All you need is a COUNTIF. Direct the formula to the Stage column in your projects sheet as shown in the second screen shot below. Then reference the stage value in your roll up sheet per the screen shot below.

Cheers,

Hudson

prime_nathaniel

@TN_RDB2025 I do not understand, why do you have a "+" within your countif?

Assuming you have "stage" as cross reference "{stage}"

=COUNTIFS({stage},"nameOfStage")

ex. Due Diligence

=COUNTIFS({stage},"Due Diligence")

TN_RDB2025

In my roll up sheet, I have a primary column that lists the phases ("Due Diligence", "Entitlements", etc.), and in the adjacent column, I want to count how many projects from my project sheet are currently in that specific phase.

ex.

=COUNTIFS({{Project List}, "Due Diligence")

I receive #PARSEABLE, what am I doing wrong?

Paul Newcome

Try this:

=COUNTIFS({Project List}, @cell = Primary@row)

Hudson_Miller

@TN_RDB2025 -

Hello -

I think you are overthinking the formula a bit. All you need is a COUNTIF. Direct the formula to the Stage column in your projects sheet as shown in the second screen shot below. Then reference the stage value in your roll up sheet per the screen shot below.

Cheers,

Hudson