Count between ranges
Options
Jason H
✭✭✭
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

This is the correct function and use for your need, @Jason H. Well done!
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!