Count between ranges
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 409 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!