Countifs with date criteria and also parsing drop down
Hi all,
Been struggling on a formula for too long. Need some assistance from some of the great minds.
I have taking information from a sheet and trying to count the amount of times a condition is met within a specific time frame.
Here is my current formula:
=COUNTIFS({IC Issue Tracker Range 7}, @cell >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, @cell <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS({IC Issue Tracker Range 2}, "Customer Care Approval"))
Range 7: Has the date stamps
Range 2: Has the criteria I am trying to count although I need to specify that it is a dropdown so 1 cell can have multiple selections.
Any help would be greatly appreciated.
Best Answer
-
@Ben77 You were really close to getting it 🙂
=COUNTIFS({IC Issue Tracker Range 7}, >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS(@cell, "Customer Care Approval"))
Let me know if that doesn't work as intended.
Answers
-
@Ben77 You were really close to getting it 🙂
=COUNTIFS({IC Issue Tracker Range 7}, >= DATE(2023, 2, 20), {IC Issue Tracker Range 7}, <= DATE(2023, 2, 26), {IC Issue Tracker Range 2}, HAS(@cell, "Customer Care Approval"))
Let me know if that doesn't work as intended.
-
Yes it worked. Thanks, much appreciated!!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!