Calculating Count of Projects by PM by Month

Hi,

Trying to create formula to calculate How many projects start in a certain month by each Project Manager - My excel formulas are weak

Master sheet has columns:

Project Manager is Contact List (does this have to be a Text/Number Column?)

Project Start Date - is Date type Column

=COUNTIFS({Keller Project Summary - MASTER Range 11}, "Gerard" , ({Keller Project Summary - MASTER Range 12}, MONTH(@Cell)=1), IFERROR(@Cell) = 1,0)

What am i doing wrong is coming up with #unparseable

Find more posts tagged with

Manufacturing

Construction

Formulas

Reports

Project Management

Comments

Nic Larsen

Try:

=COUNTIFS({Keller Project Summary - MASTER Range 11}, "Gerard" , ({Keller Project Summary - MASTER Range 12}, IFERROR(MONTH(@cell), 0) =1)

This is only counting Projects with in January. Change the "=1" to 2, 3, and so on to count additional months...

Paul Newcome

An explanation of Nic's solution:

You have the IFERROR misplaced. Generally I find it easier to work from the inside out when doing formulas like this. I will start with what I know I want

MONTH(@cell)

and then wrap it in he next portion

IFERROR(MONTH(@cell), 0) = 1

The way IFERROR works is

=IFERROR(data to display, data to display if the first set is an error)

So you would take the MONTH(@cell) and just drop that directly into the first portion of your IFERROR statement.

Sign in to join the conversation!

Quick Links

Trending discussions

A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…