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

John Jonassen

This is the correct function and use for your need, @Jason H. Well done!