Calculating Count of Projects by PM by Month

Kelcon

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

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.