CountIf with Date ranges
Trying to write a formula that counts the number of instances based on a date range. I can get the instances to populate in a formula by themselves but I cannot get the date range to work?
This is weird as the formula works in another sheet for another scenario.
=COUNTIFS({CURRENT CHECKOUT SCENARIO Range 1}, [Primary Column]@row, {CURRENT CHECKOUT SCENARIO Range 2}, AND(@cell >= DATE(1965, 1, 30), @cell <= DATE(2021, 4, 30)))
Answers
-
Are you getting an error or an incorrect count?
-
Hi @JScot
Can you clarify what you mean when you say you can't get it to work? Are you receiving an error or an incorrect result? The structure of the formula is correct, so it may be that there's an issue with the ranges or the criteria.
Check to make sure that your "Range 2" is looking at a Date Type of column. If it is, could you post screen captures of each range and the current sheet (but please block out sensitive data).
Thanks!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!