COUNTIFS and DATE RANGE

shussain

Hello Everyone!

I followed a lot of the tips and suggestions that were already on the threads and for some reason I am unable to get the formula to do what I want it to do!

I am trying to figure out how many of our initiatives are in a certain stage during a certain date range.

The formula that I am using is

=COUNTIFS({Ideation Team Tracker Demo Range 3}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 1, 31)), {Ideation Team Tracker Demo Range 3}, "L0")

The formula itself does not give me an error, the answer comes back as 0 when it should be 1.

Now when I break apart the formula to just the following:

=COUNTIFS({Ideation Team Tracker Demo Range 3}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 1, 31)) = 1

and

=COUNTIFS({Ideation Team Tracker Demo Range 3}, "L0") = 4

It gives me the correct answer, as listed above.

What am I doing wrong?

Eric Law

@shussain how are both the ranges the same, {Ideation Team Tracker Demo Range 3} ? Doesn't make sense that it can be both a date AND and an initiative.

Eric Law

@shussain how are both the ranges the same, {Ideation Team Tracker Demo Range 3} ? Doesn't make sense that it can be both a date AND and an initiative.

shussain

That was it!! I changed the ranges and it worked. Thank you!