Formula to count specific month

HueyD

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)+""))

Mark Cronk

Hi @HueyD ,

You need to use a COUNTIFS function to include multiple criterion. The syntax is: COUNTIFS( range1 criterion1 [ range2​criterion2​... ])

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

Mark Cronk

Hi @HueyD ,

You need to use a COUNTIFS function to include multiple criterion. The syntax is: COUNTIFS( range1 criterion1 [ range2​criterion2​... ])

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

HueyD

Thanks Mark, it works. Can't believe I missed that step