COUNTIFS Percent Range Question

Christopher Rich

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!

Paul Newcome

Try something like this...

COUNTIFS({Completed Strategy Updates (Strategy Prima Range 2}, "1", {Completed Strategy Updates (Strategy Prima Range 1}, AND(@cell > 0.50, @cell < 0.76))