Formula to count specific month
Hi,
I'm trying to count a number of projects for a timeline creation. I need a formula to count a project that started in a specific month. My current formula does not work :( this is my formula
=COUNTIF({Project Type}, "Non-infra", {Project or Milestone}, "Project", {start date}, >=DATE(2020, 1, 1), AND({start date}, <= (2020, 31, 01)+""))
Best Answer
-
Hi @HueyD ,
You need to use a COUNTIFS function to include multiple criterion. The syntax is: COUNTIFS( range1 criterion1 [ range2criterion2... ])
Your formula would be:
=COUNTIFS({Project Type}, "Non-infra", {Project or Milestone}, "Project", {start date}, >=DATE(2020, 1, 1), {start date}, <= (2020, 31, 01))
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @HueyD ,
You need to use a COUNTIFS function to include multiple criterion. The syntax is: COUNTIFS( range1 criterion1 [ range2criterion2... ])
Your formula would be:
=COUNTIFS({Project Type}, "Non-infra", {Project or Milestone}, "Project", {start date}, >=DATE(2020, 1, 1), {start date}, <= (2020, 31, 01))
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks Mark, it works. Can't believe I missed that step
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!