Count between ranges


Reaching out to see if my formula, which seems to be working, is the correct way to COUNT between two ranges.

In my example - I want to count a category name AND only if the % Complete range is between 25% - 49%


=COUNTIFS({Function}, "Asset Protection", {Percent}, >0.25, {Percent}, <=0.49)

As mentioned this seems to be pulling data back but I'm sure there is a much better formula.

Thanks - J



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!