COUNTIFS Percent Range Question

Is there a formula I can use to reference separate sheets and get a range of items within a set percentage? Such as all items between 0 and 25%, 26% and 50%, 51% and 75% and 76%-100%? I have tried the below formula but it does not report correctly. What am I missing?:

COUNTIFS({Completed Strategy Updates (Strategy Prima Range 2}, "1", {Completed Strategy Updates (Strategy Prima Range 1}, "0.51-.75")

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!