# COUNTIFS and DATE RANGE

Options
✭✭
edited 10/19/23

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?

Tags:

• ✭✭✭✭✭✭
Options

@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.

• ✭✭✭✭✭✭
Options

@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.

• ✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!