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
Comments
-
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...
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!