Search for values between two numbers

EMueller

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!

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"))