Count between ranges

Options

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%

FORMULA

=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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!