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

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?