COUNTIFS when value falls between X and Y
Options
Chris Hallo
✭✭✭✭
Hello! So, my summary field for 0030 days (using Days Open) works fine. I'm running into issues though on 3160, 6190 and 91180...not sure the syntax for the range. Help, please :)!!
Best Answers

Something like this should work. Just update the formula for each range:
=COUNTIFS([Days Open]:[Days Open], >30, [Days Open]:[Days Open], <=60)

Thanks, Nic. I just added an equal sign between and 30 and all good. I appreciate the prompt reply :).
Answers

Something like this should work. Just update the formula for each range:
=COUNTIFS([Days Open]:[Days Open], >30, [Days Open]:[Days Open], <=60)

Thanks, Nic. I just added an equal sign between and 30 and all good. I appreciate the prompt reply :).
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!