What am I doing wrong? Trying to count how many say not started in the month of dec 2020.

DeMetria Hines

COUNTIFS({Request Tracker Range 2 - Status}, CONTAINS("Not Started") >= DATE(2020, 12, 1), {Report Request (Test Version) Range 3}, <=DATE(2020, 12, 31))

DeMetria Hines

Thank you @Mark Cronk & @Mike Wilday I will try it out and see if it works.

Mike Wilday

What are you trying to do with teh Contains("Not Started") bit there?

Mark Cronk

Hi @DeMetria Hines ,

Try:

=COUNTIFS({Request Tracker Range 2 - Status}, "Not Started", {Report Request (Test Version) Range 3}, month(@cell)=12))

Assumes your status is in range 2 and dates in range 3.

Mark

DeMetria Hines

Range 2 is a drop down, so I am trying to count how many in that column set to not started in the month of December.

Mike Wilday

I think Mark's solution would work for you. Have you tried it out?

=COUNTIFS({Request Tracker Range 2 - Status}, "Not Started", {Report Request (Test Version) Range 3}, month(@cell)=12))

Mike Wilday

However, If you want to restrict it to a specific date range. This one should work for you too :

=COUNTIFS({Request Tracker Range 2 - Status}, "Not Started", {Report Request (Test Version) Range 3}, And(@cell >=DATE(2020, 12, 1), @cell <= Date(2020, 12, 31)))

DeMetria Hines

Thank you @Mark Cronk & @Mike Wilday I will try it out and see if it works.

Mike Wilday

Awesome. Let us know if you have any trouble.