Search for values between two numbers

I have this Code:

=COUNTIFS({GDP Project Tracker Range 5}, @cell < 0.05, {GDP Project Tracker Range 3}, OR(@cell = "Active", @cell = "Launched", @cell = "Planned"))

Looking to make it find between 0.05 and 0.1 rather then just less then 0.05. Any help would be much appreciated!

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    This will match anything BETWEEN 0.05 and 0.01. If you want to INCLUDE 0.05 and 0.01, replace "<" and ">" with "<=" and ">=".

    =COUNTIFS({GDP Project Tracker Range 5}, @cell < 0.05, {GDP Project Tracker Range 5}, @cell > 0.01,   {GDP Project Tracker Range 3}, OR(@cell = "Active", @cell = "Launched", @cell = "Planned"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!