COUNTIFS + AND + DATE RANGES
Hi! and HELP! :/
I'm trying to pull data from a tracker that counts issues that take longer than 2 days to resolve, for a specific company, within a month. Below is an example of what I have tried. I've tweaked, re-done, ad nauseum... I can get the company + days and I can get the dates, but when I try and marry them up with "AND" I lose it.
=COUNTIFS({Company}"Target", {Duration to Close}>2, AND(@cell >= DATE(2024, 2, 1), @cell <= DATE(2024, 2, 29)))
Best Answer
-
If I understand correctly, you can avoid the AND condition entirely since COUNTIFS handles multiple conditions. I'm not sure what the range is that you are comparing for dates. I used {Date Range} here, but you will have to replace those two entries with your actual reference. If I am misunderstanding, please let me know.
=COUNTIFS({Company}, "Target", {Duration to Close}, @cell > 2, {Date Range}, @cell >= DATE(2024, 2, 1), {Date Range}, @cell <= DATE(2024, 2, 29))
Answers
-
If I understand correctly, you can avoid the AND condition entirely since COUNTIFS handles multiple conditions. I'm not sure what the range is that you are comparing for dates. I used {Date Range} here, but you will have to replace those two entries with your actual reference. If I am misunderstanding, please let me know.
=COUNTIFS({Company}, "Target", {Duration to Close}, @cell > 2, {Date Range}, @cell >= DATE(2024, 2, 1), {Date Range}, @cell <= DATE(2024, 2, 29))
-
Thank you SO much!! I am immeasurably grateful!!
-
Glad to help! COUNTIFS is a great function, you can do a lot with it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!